Home » RDBMS Server » Performance Tuning » Difference Between Global Index and Local Index
Difference Between Global Index and Local Index [message #204724] Tue, 21 November 2006 20:55 Go to next message
juliee_jitu
Messages: 8
Registered: July 2006
Junior Member
Hi,
I have created range partition one table .
Is it required to create Global Index or Local Index ?
For performance issue.. which one should create ?

Plz help me ?

Thanks in advance.
Re: Difference Between Global Index and Local Index [message #204732 is a reply to message #204724] Tue, 21 November 2006 22:32 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

hi juliee,

Global Index : A single index covering all partitions.

Local Index : Separate indexes for each partition. A local index can be unique. However, in order for a local index to be unique, the partitioning key of the table must be part of the index's key columns. Unique local indexes are useful for OLTP environments. You cannot explicitly add a partition to a local index. Instead, new partitions are added to local indexes only when you add a partition to the underlying table.


Range Partitioning :
http://www.oracle-base.com/articles/8i/PartitionedTablesAndIndexes.php#Range

Range Partitioning with Global Indexes.

http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14231/partiti.htm


You should go for Global Indexes.

hope this helps
Taj.
Previous Topic: Which Partition to Apply? What should be the partition key?
Next Topic: Partitioning Tables
Goto Forum:
  


Current Time: Mon Dec 05 03:00:01 CST 2016

Total time taken to generate the page: 0.17385 seconds