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 -> Tracing use of indexes

Tracing use of indexes

From: jeroen <zandvoort_at_geocities.com>
Date: 27 Jul 1998 16:34:46 GMT
Message-ID: <35bc907a.450892@news.euronet.nl>


Hello,

I hope sonebody can help with the following probleem. I have a well used table with 8 indexes defined on that. I would like to know if all are being used and if i know a way i would like to check all indexes. Does somebody know how to find out, tools ? Is auditing an option and if so how ?
Thanks in advance,

Jeroen Received on Mon Jul 27 1998 - 11:34:46 CDT

Original text of this message

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