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 -> Measuring index usage

Measuring index usage

From: <jantah_at_my-deja.com>
Date: Mon, 25 Sep 2000 13:12:29 GMT
Message-ID: <8qnivd$cj9$1@nnrp1.deja.com> 






I would like to identify indexes that are not used to access tables (and
thus only slow the system down). Is there a system view or other method
to indetify these indexes, or is this a trial and error process?



(Using Oracle 7.3.3)



Thanks in advance,


Jan




Sent via Deja.com http://www.deja.com/


Before you buy.
Received on Mon Sep 25 2000 - 08:12:29 CDT












Original text of this message













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