ITPub博客

big和small表的结构是一样的create table big as select * from dba_objects;create table small as select * from dba_objects;alter table big modify object_id  null;create index idx_big on big(obj...

SQL> create table indsplit as select object_id from dba_objects;Table createdExecuted in 0.75 secondsSQL> create index ind_split on indsplit (object_id) pctfree 1;Index createdExecuted in 0.093 second...