Re: partitions

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Fri, 19 Nov 2004 07:59:13 +1100
Message-ID: <419d0d22$0$2681$afc38c87@news.optusnet.com.au>

Oradba Linux wrote:
> 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

It's not that the indexes are marked as invalid. It's that they are marked as unusable.

If I get a chance, I'll post more details shortly.

HJR Received on Thu Nov 18 2004 - 14:59:13 CST