RE: best way to identify an unused index
- From: "Powell, Mark D" <mark.powell@xxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 12 May 2005 16:12:33 -0400
Chirag, the height of a normal Oracle index is pretty much a function of
the number of entries in the index and generally does not have a direct
bearing on the state of the index.=20
HTH -- Mark D Powell --
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Chirag DBA
Sent: Thursday, May 12, 2005 3:23 PM
To: Paula_Stankus@xxxxxxxxxxxxxxx
Cc: arivenes@xxxxxxxx; dba.orcl@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: 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=3D20
On 5/12/05, Paula_Stankus@xxxxxxxxxxxxxxx
<Paula_Stankus@xxxxxxxxxxxxxxx> w=3D
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
