RE: Index Usage

        Sorry Lisa. I didn't understand it so.

	-----Mensaje original-----
	De:	Lisa_Koivu_at_gelco.com [SMTP:Lisa_Koivu_at_gelco.com]
	Enviado el:	martes 9 de mayo de 2000 18:15
	Para:	Multiple recipients of list ORACLE-L
	Asunto:	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)




	     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).






	-- 
	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