Re: best way to identify an unused index

Unused means I am assuming here that the index which was working now due to getting splitted it is not working now.

You can go to index_stats view and check the value of column height, if that exceeds 4, it means yr index has got splitted. You need to rebuild index.

You can check explain_plan to see whether it is working or not?

If INDEX is not splitted, you need to generate statistics for CBO and at last you can use hint to make the index getting used in the query extensively.

Hope I m on the right way,

Regards - Chirag=20

On 5/12/05, Paula_Stankus_at_doh.state.fl.us <Paula_Stankus_at_doh.state.fl.us> w= rote:
> In Oracle 9i what is the best way to identify an unused index?
> --
> http://www.freelists.org/webpage/oracle-l
>

--
http://www.freelists.org/webpage/oracle-l