oracle sql调优系列之8(局部前缀索引和局部非前缀索引)

SQL> drop table test;

Table dropped.

SQL> create table test(id number(10),y varchar2(20))partition by range(id)(partition p1 values less than(1000),partition p2 values less than(10000));

Table created.

 

 

SQL> exec dbms_stats.set_table_stats(ownname =>'SCOTT',tabname =>'TEST',numrows =>'100000',numblks =>'40000',partname=>'p1');

PL/SQL procedure successfully completed.

Commit complete.

SQL> exec dbms_stats.set_table_stats(ownname =>'SCOTT',tabname =>'TEST',numrows =>'100000',numblks =>'40000',partname=>'p2');

PL/SQL procedure successfully completed.

 

待续

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/8410760/viewspace-732807/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/8410760/viewspace-732807/