Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: REPOST: Re: global index and local index
Uwe Schneider wrote:
> frank wrote:
>> >> Hello, >> >> Does global index and local index concept used only in partition?
>> Please give me an explanation on what's the difference of them.
That's plain wrong. Local indexes are partitioned with the same
partitioning key (or a subset) as the table.
Global partitioned indexes can have
a different partioning key. They can even be partitioned with the
same key and still be global partitioned, because local indexes
have to be created with the table. The difference is that in a global
index one index partition may refer to more than one underlying
table partition.
The main difference is in the maintenance/administration overhead between the two.
Hope this helps
Stefan
> Uwe
>
Received on Mon Dec 31 2001 - 22:51:59 CST