Home » SQL & PL/SQL » SQL & PL/SQL » Local index vs global index in partitioned tables
Local index vs global index in partitioned tables [message #187027] Thu, 10 August 2006 10:02 Go to next message
Messages: 24
Registered: October 2004
Junior Member


I want to know the differences between a global and a local index.

I'm working with partitioned tables about 10 millons rows and 40 partitions.
I know that when your table is partitioned and your index non-partitioned is possible that
some database operations make your index unusable and you have tu rebuid it, for example
when yo truncate a partition your global index results unusable, is there any other operation
that make the global index unusable??

I think that the advantage of a global index is that takes less space than a local and is easier to rebuild,
and the advantage of a local index is that is more effective resolving a query isn't it???

Any advice and help about local vs global index in partitioned tables will be greatly apreciatted.

Thanks in advance
Re: Local index vs global index in partitioned tables [message #187060 is a reply to message #187027] Thu, 10 August 2006 13:12 Go to previous message
Messages: 817
Registered: December 2005
Senior Member
I think you are getting it wrong..except for very few reasons, it is almost allways better to have local index then global..that is what I remember having read..but you can go through all details at the docs :


and check out the site asktom.oracle.com or read his expert one on one for more details..

Previous Topic: from csv to pl/sql array
Next Topic: Committing Large Amounts of Data
Goto Forum:

Current Time: Sun Aug 20 06:54:59 CDT 2017

Total time taken to generate the page: 0.01134 seconds