diff: global index and a local index
What is the difference between a global index and a local index.
well one is global to the table, one is local to a partition
what else you want to know?
So if you have a partitioned table and you have a global index, does that mean that it is one self contained object with values for all the partition? How does the local index differ?
davey23uk comment self explainatory. Isn't it ? Create one local and other global index and observe the underlying structures you should be able to figure out.
Local index is @ partition level and indexed based on the partition data only where as global index, indexed on the whole table(all partitions).
confusion about local index and global index
Hi to all,
I am in confusion about local index and global index.
Give some example where the global index is been used and where the local index is been used?
create index zzz on table1(x);
create index yyy on table1(x)
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
Click Here to Expand Forum to Full Width