partitions

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 Received on Wed Nov 17 2004 - 05:37:23 CST