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
Messages: 8
Registered: July 2006
Junior Member
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 :

Range Partitioning with Global Indexes.


You should go for Global Indexes.

hope this helps
Previous Topic: Bothering "Sudden Death" by unexpected dropping efficient execution plan
Next Topic: Partitioning Tables
Goto Forum:

Current Time: Mon Aug 21 12:56:15 CDT 2017

Total time taken to generate the page: 0.04275 seconds