DA Morgan wrote:
> 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
We are on an OLTP system where data in fast growing tables need to be
purged on frequent basis. We opted to do partitioning . Tests indicate
the drop partition with UGI is slow but does not cause a downtime. I
assume lot of shops wanted to do this way and could be reason for Oracle
to come up with UGI. I may be wrong.
Received on Thu Nov 18 2004 - 12:08:10 CST
