oracle全表扫描的3种优化手段

SQL> conn scott/tiger
Connected.
SQL> drop table t1;

Table dropped.

SQL> create table t1 as select * from emp;

Table created.

SQL> insert into t1 select * from t1;

14 rows created.

SQL> /

28 rows created.

SQL> /

56 rows created.

SQL> /

112 rows created.

SQL> /

224 rows created.

SQL> /

448 rows created.

SQL> /

896 rows created.

SQL> /

1792 rows created.

SQL> /

3584 rows created.

SQL> /

7168 rows created.

SQL> /

14336 rows created.

SQL> /

28672 rows created.

SQL> /