Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Identify unused indexes in 8i ?

RE: Identify unused indexes in 8i ?

From: Bob Robert <mssql_2002_at_yahoo.com>
Date: Thu, 29 Aug 2002 14:38:58 -0800
Message-ID: <F001.004C35CC.20020829143858@fatcity.com>


Indexes were never used. They must have been created for temporary purpose.
--- &#34;Gogala, Mladen&#34; &lt;MGogala_at_oxhp.com&gt; wrote:
&gt; What are &#34;unused indexes&#34;?
&gt;
&gt; &gt; -----Original Message-----
&gt; &gt; From: Bob Robert

[mailto:mssql_2002_at_yahoo.com]
&gt; &gt; Sent: Thursday, August 29, 2002 3:33 PM
&gt; &gt; To: Multiple recipients of list ORACLE-L
&gt; &gt; Subject: Identify unused indexes in 8i ?
&gt; &gt;
&gt; &gt;
&gt; &gt; All,
&gt; &gt;
&gt; &gt; Is there a way to identify unused indexes in
&gt; Oracle
&gt; &gt; 8i. I know that it is easy to check with 9i.
I
&gt; would
&gt; &gt; appreciate if you could share your
experience (or
&gt; &gt; ideas) with me.
&gt; &gt;
&gt; &gt; Thanks,
&gt; &gt; Bob
&gt; &gt;
&gt; &gt;
&gt; &gt;
&gt; &gt;



&gt; &gt; Do You Yahoo!?
&gt; &gt; Yahoo! Finance - Get real-time stock quotes
&gt; &gt; http://finance.yahoo.com
&gt; &gt; --
&gt; &gt; Please see the official ORACLE-L FAQ:
&gt; http://www.orafaq.com
&gt; &gt; --
&gt; &gt; Author: Bob Robert
&gt; &gt; INET: mssql_2002_at_yahoo.com
&gt; &gt;
&gt; &gt; Fat City Network Services -- (858)
538-5051
&gt; FAX: (858) 538-5051
&gt; &gt; San Diego, California -- Public
Internet
&gt; access / Mailing Lists
&gt; &gt;
&gt;


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


&gt; To REMOVE yourself from this mailing list, send
an
&gt; E-Mail message
&gt; to: ListGuru_at_fatcity.com (note EXACT spelling of
&gt; 'ListGuru') and in
&gt; the message BODY, include a line containing:
UNSUB
&gt; ORACLE-L
&gt; (or the name of mailing list you want to be
removed
&gt; from). You may
&gt; also send the HELP command for other information
&gt; (like subscribing).


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).
Received on Thu Aug 29 2002 - 17:38:58 CDT

Original text of this message

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