Re: What type of index is best for a large partitioned table?

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 23 Jul 2006 14:48:55 -0700
Message-ID: <1153691335.392541.209470@m73g2000cwd.googlegroups.com>

Dereck L. Dietz wrote:
> What type of index is best for a large partitioned table of about 69 million
> rows?
>
> A global partitioned index or local partitioned index? Or do we need both
> types?
>
> Thanks.

Generally speaking you would want all the partitioned indexes on a partitioned table to be locally partitioned if possible. That way when you perform partition operations such as dropping or moving a paration only the local indexes are affected minimizing the affect of the action.

If you do something that invalidates a global index the rebuild will affect DML access to the entire partitioned table.

HTH -- Mark D Powell -- Received on Sun Jul 23 2006 - 16:48:55 CDT