OraFAQ Forum: Performance Tuning » Difference Between Global Index and Local Index

Home » RDBMS Server » Performance Tuning » Difference Between Global Index and Local Index

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Difference Between Global Index and Local Index [message #204724]

Tue, 21 November 2006 20:55

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.

Report message to a moderator

Re: Difference Between Global Index and Local Index [message #204732 is a reply to message #204724]

Tue, 21 November 2006 22:32

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.

Report message to a moderator

Previous Topic:	Which Partition to Apply? What should be the partition key?
Next Topic:	Partitioning Tables

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 02 03:38:07 CDT 2024