-
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?
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).
Reddy,Sam
-
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?
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
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|