SQL> create table test as select * from user_objects;表已创建。SQL> create table test1 as select * from dba_objects;表已创建。SQL> create unique index i_test_1 on test(object_id);索引已创建。SQL> analyze table test compute statistics;表已分析。SQL> analyze table test1 compute statistics;表已分析。SQL> select test1.* from test,test1 where test.object_id=test1.object_id;Execution Plan----------------------------------------------------------0
