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

Home -> Community -> Usenet -> c.d.o.server -> How to determine unused indexes

How to determine unused indexes

From: Michael Gill <mydba_at_usa.com>
Date: 22 Mar 2002 19:12:26 -0800
Message-ID: <fb510dcd.0203221912.606baa6f@posting.google.com> 





Given that I have numerous indexes, how can I determine which ones are
NOT used. I could check each query with explain plan, but is there an
easier method? Is there some v$ table that counts hits on an index?



Thanks
Received on Fri Mar 22 2002 - 21:12:26 CST












Original text of this message













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