Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Measuring index usage
Not used?
1) Sometimes indexes are not used, and for a good reason.
2) Non used indexes only slow down upon inserts, updates, deletes.
Not so for retrieval
3) No, there is no view - but it's not all trial and error. Trace and
explain plan
are the keywords you are looking for. And, of course:
4) the documentation that came with the system (you *do* have
documentation?)
There must be a reason for that index... (well, some developers....)
-- Frank <jantah_at_my-deja.com> schreef in berichtnieuws 8qnivd$cj9$1_at_nnrp1.deja.com...Received on Mon Sep 25 2000 - 08:38:17 CDT
> 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.