Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Identify unused indexes in 8i ?
I would assume any index that was created but never used by the optimizer. He probably wants to know if not ever used drop them. I have no idea if it is possible to determine if an index was "used".
"Gogala, Mladen" To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> <MGogala_at_oxhp. cc: com> Subject: RE: Identify unused indexes in 8i ? Sent by: root_at_fatcity.c om 08/29/2002 04:38 PM Please respond to ORACLE-L
What are "unused indexes"?
> -----Original Message-----
> From: Bob Robert [mailto:mssql_2002_at_yahoo.com]
> Sent: Thursday, August 29, 2002 3:33 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Identify unused indexes in 8i ?
>
>
> All,
>
> Is there a way to identify unused indexes in Oracle
> 8i. I know that it is easy to check with 9i. I would
> appreciate if you could share your experience (or
> ideas) with me.
>
> Thanks,
> Bob
>
>
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Finance - Get real-time stock quotes
> http://finance.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Bob Robert
> INET: mssql_2002_at_yahoo.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).
>
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: MGogala_at_oxhp.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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: Rick_Cale_at_teamhealth.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).Received on Thu Aug 29 2002 - 16:13:24 CDT
![]() |
![]() |