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

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.

Almost always local.

Now as to whether that should be a B*Tree, bitmap, bitmap join, compressed, descending, function based, or reverse key index? That would be quite another matter entirely.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org