Re: partitions

Oradba Linux wrote:

> I have a partitioned table and only global indexes. When i do a count on
> a single partition, it uses the global index and accesses the table. It
> is painfully slow. Is there a way to force it fullscan a partition alone?
> Also how do i know if the global non partitioned index is in a unusable
> state after the ddl on the partitions without using "update global
> indexes" clause.
>
> Oracle 9204 / Sun os 32 bit

Why global indexes? It pretty much defeats the entire point of using partitions? And is the cause of the issue you face.

BTW: If you have current statistics ... why not query the data dictionary?

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)