Re: global index and local index

frank wrote:
>
> Hello,
>
> Does global index and local index concept used only in partition?

I have heard about them only in conjunction with partitions.

> Please give me an explanation on what's the difference of them.

Local indexes are partitioned in the same manner as the table segment, i.e. the index data are in the same partition as the corresponding table data. Global index segments are unpartitioned.

Uwe

-- 
Uwe Schneider       | Telefon +49 7244 / 609504
Haydnstr. 1         | Mail    uwe_at_richard-schneider.de
DE-76356 Weingarten | http://www.richard-schneider.de/uwe
Linux - OS al dente!