This forum is currently locked. You can't register or post questions at this time. (read more)

Global index vs Local index while creating the partition tab

All posts relating to Oracle database administration.

Moderator: Tim...

shoan
Senior Member
Posts: 123
Joined: Thu Mar 17, 2011 6:27 am

Global index vs Local index while creating the partition tab

Postby shoan » Mon Oct 01, 2012 8:48 pm

Hi Team,

Would you please any one suggest me , what is the best practice for creating the indexes(Global indexes or local indexes) while creating the partition table in oracle ?

Which scenario the creating of global indexes are suitable for partition table and Which scenario the local indexes are suitable for partition table ?

Can you please any one provide me the suitable doc for the same.

Thanks in Advance.
Shoan

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: Global index vs Local index while creating the partition

Postby Tim... » Mon Oct 01, 2012 11:58 pm

Hi.

From a manageability perspective, local indexes are really neat as they track the table partitions exactly.

I don't know any specific examples of documents that answer your question. I guess where I would start is by looking through Richard Foote's blog posts.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog


Return to “Oracle Database Administration”

Who is online

Users browsing this forum: No registered users and 5 guests