Index Series 7-the low height of index characteristics is a sharp tool for optimization.
Sqlplus ljb/ljb
Drop table t1 purge
Drop table t2 purge
Drop table t3 purge
Drop table t4 purge
Drop table t5 purge
Drop table t6 purge
Drop table t7 purge
Create table T1 as select rownum as id, rownum+1 as id2,rpad ('*', 1000 cymbals) as contents from dual connect by level