create index zzz on table1(x);
create index yyy on table1(x)
LOCAL;
one is local to the partition, one is global.
e.g you can rebuild a partitioned index partition by partition - helps when doing a full index scan as you only have to scan the index partition




Reply With Quote