Re: Dropping Index Partitions

From: Dave Haas <davidh_at_--nospam--hotmail.com>
Date: Sun, 04 Mar 2001 19:05:13 GMT
Message-ID: <Jlwo6.9451$pF4.2012683@news1.telusplanet.net>

Hi Buck.

The answer lies in the definition of "local" index.

Basically, a local index HAS to have the same # of partitions as the table it indexes. You therefore cannot drop one local index partition because then the number of partitions in the table and the number of partitions in the index would be different.

A global index, on the other hand, does not have the requirement that the # of index and table partitions be the same. So if you drop an global index partition, things essentially get redistributed among the remaining partitions (because you can only drop a hash partition if memory serves).

HTH, Dave Haas

"Buck Turgidson" <remove-me_jc_va_at_hotmail.com> wrote in message news:EHto6.3067$Ey1.234585_at_bgtnsc06-news.ops.worldnet.att.net...
> I am having trouble seeing this in my mind. Why can't one drop an index
partition
> on a local index? I am reading that it is only possible for a global
index.
>
> thanks for any replies.
>
>
Received on Sun Mar 04 2001 - 13:05:13 CST