RE: best way to identify an unused index

From: Ruth Gramolini <rgramolini_at_tax.state.vt.us>
Date: Thu, 12 May 2005 14:18:14 -0400
Message-ID: <00ae01c5571e$f63a52e0$8459000a@vttaxnet.tax.state.vt.us>

Here is a script which create the view v$object_useage. You can turn monitoring on all indexes and then query the view to show which were used. The used column get reset whenever you analyze the tables and indexes so caveat emptor. You will want to monitor the indexes for a few days to see which are never used.

HTH,
Ruth

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Paula_Stankus_at_doh.state.fl.us
Sent: Thursday, May 12, 2005 1:58 PM
To: arivenes_at_llnl.gov; dba.orcl_at_gmail.com; oracle-l_at_freelists.org Subject: RE:best way to identify an unused index

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 - 14:22:48 CDT