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
Nau
Messages: 24
Registered: October 2004
Junior Member

Hi,

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

Report message to a moderator

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
orausern
Messages: 826
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 :

http://download-east.oracle.com/docs/cd/B10501_01/server.920/a96524/c12parti.htm#459801

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

Report message to a moderator

Previous Topic: Help with Logic
Next Topic: Insert value 'G&D PREPAGO' doesn`t work
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Dec 03 15:54:49 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.