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

Home -> Community -> Usenet -> c.d.o.tools -> how to identify unused indexes

how to identify unused indexes

From: Scott Dudley <scott_at_telesoft.com>
Date: 2000/08/10
Message-ID: <399354EB.A91F9E81@telesoft.com>#1/1

is there a way to identify indexes that aren't accessed for select/update? trying to identify superfluous indexes in a database of some 300+ tables without having to go through hundreds of thousands of lines of code.

thanks.

--

Microsoft gives you Windows but Unix gives you the whole house!
Received on Thu Aug 10 2000 - 00:00:00 CDT

Original text of this message

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