You might have created local indexes on partition table so as a result
when you drop the partition then at that time the local indexes on the
partition table gets unusable and the only option left is to drop and
then recreate that index.

With Regards,



Amar P Singh



-----Original Message-----
From: Tavousi Mahnaz
[mailto:oracledba-ezmlmshield-x33918450.[Email address protected]
Sent: Tuesday, May 30, 2006 11:31 PM
To: LazyDBA Discussion
Subject: Unused index?


Hello,

I have a table which is partitioned based on period, the indexes are
partitioned too but the status of them is unusable. Would you please
tell me what dose it mean and how it affect on my queries performance.

Thanks
Mahnaz Tavousi
> ACNielsen Company of Canada
> Tel: 905-475-3344 ext 2615
> e-mail: Mahnaz.[Email address protected]
>
>


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page