diff: global index and a local index

[Natik]

What is the difference between a global index and a local index.

[davey23uk]

well one is global to the table, one is local to a partition

what else you want to know?

[Natik]

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.

[sreddy]

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).

[pbmistry]

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

[davey23uk]

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

[marist89]

http://download-west.oracle.com/docs...i.htm#CNCPT312
http://download-west.oracle.com/docs...rti.htm#461030