Re: best way to identify an unused index
- From: Chirag DBA <chiragdba@xxxxxxxxx>
- To: Paula_Stankus@xxxxxxxxxxxxxxx
- Date: Fri, 13 May 2005 00:52:32 +0530
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@xxxxxxxxxxxxxxx <Paula_Stankus@xxxxxxxxxxxxxxx> w=
rote:
> In Oracle 9i what is the best way to identify an unused index?
> --
> //www.freelists.org/webpage/oracle-l
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
