oracle 多表关联性能差,大小表关联的性能问题，急啊

SQL> create table temp1(id varchar2(10),mc varchar2(60));

Table created

SQL> create table temp2(id varchar2(10),mc varchar2(60));

Table created

SQL> begin

2  for i in 1..100000 loop

3  insert into temp1 values(i,i);

4  end loop;

5  end;

6  /

PL/SQL procedure successfully completed

SQL> commit;

Commit complete

SQL> insert into temp2 values(1,1);

1 row inserted

SQL> insert into temp2 values(100,100);

1 row inserted

SQL> create index idx_temp1 on temp1(id);

Index created

SQL> create index idx_temp2 on temp2(id);

Index created

SQL> select count(*) from temp1;

COUNT(*)

----------

100000

执行计划

----------------------------------------------------------

0      SELECT STATEMENT Optimizer=CHOO