Re: partitions

From: Oradba Linux <oradba_linux_at_comcast.net>
Date: Thu, 18 Nov 2004 18:05:40 GMT
Message-ID: <Uv5nd.526701$mD.297587@attbi_s02>

Howard J. Rogers 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

>
>
>
> What do you mean "how do I know if the global index is unusable after
> partition ddl if I didn't do an 'update global indexes'"? By definition,
> the global indexes are invalidated by any partition DDL *unless* you do
> an update global indexes. You don't need to "know it", they just are.
>
> But if you need to see it for yourself, try dba_indexes.
>
> Regards
> HJR

Howard ,

Thanks for your response. I checked in dba_indexes after doing DDL on partitioned table with Global indexes, the status column was still valid. Let me know if i am looking at the wrong column.

Thanks Received on Thu Nov 18 2004 - 12:05:40 CST