Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: best way to identify an unused index

Re: best way to identify an unused index

From: Chirag DBA <chiragdba_at_gmail.com>
Date: Fri, 13 May 2005 00:52:32 +0530
Message-ID: <1a36296005051212221819411e@mail.gmail.com>


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
Received on Thu May 12 2005 - 15:27:04 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US