RE: Index Usage

Do you mean explain plan? I don't have time to explain all the reports. Besides I am now pushing that back to the DEVELOPERS. :) They need to learn how to execute and interpret this sometime.

I was wondering if there was some magical way to look somewhere and see how many times an index has been hit in the last 12 hours or so.

Miguel Urosa <murosa_at_smseuropa.com> on 05/09/2000 10:51:51 AM

Please respond to ORACLE-L_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc: (bcc: Lisa Koivu/GELCO)

Subject: RE: Index Usage

     What about to use PLAN SQL statement?.

     HTH.      Miguel.

     -----Mensaje original-----
     De:  Lisa_Koivu_at_gelco.com [SMTP:Lisa_Koivu_at_gelco.com]
     Enviado el:    martes 9 de mayo de 2000 17:10
     Para:     Multiple recipients of list ORACLE-L
     Asunto:   Index Usage

     Hello -

     Does anyone have a quick and dirty way to tell if an index is being
used?  This
     is a DW environment.

     Thanks
     Lisa





     --
     Author:
       INET: Lisa_Koivu_at_gelco.com

     Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
     San Diego, California        -- Public Internet access / Mailing
Lists
     --------------------------------------------------------------------
     To REMOVE yourself from this mailing list, send an E-Mail message
     to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
     the message BODY, include a line containing: UNSUB ORACLE-L
     (or the name of mailing list you want to be removed from).  You may
     also send the HELP command for other information (like subscribing).

--
Author: Miguel Urosa
  INET: murosa_at_smseuropa.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).