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