What is the difference between a global index and a local index.
Printable View
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?
Thanks.
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).
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?
Mistry Pradip
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