Re: INDEX USAGE

From: Jan Gelbrich <j_gelbrich_at_westfalen-blatt.de>
Date: Wed, 4 Jun 2003 09:10:16 +0200
Message-ID: <bbk63v$ae6v1$1@ID-152732.news.dfncis.de>

Hi, Paul,

if You have 8i, there is an excellent article about just that problem by John Weeg
"Is the index still being used ?"
at www.dbazine.com.

Else You might examine v$object_usage in 9i.

hth, Jan

>"Paul" <paul821_at_yahoo.com> schrieb im Newsbeitrag
news:DseDa.11886$sG3.3838538_at_news4.srv.hcvlny.cv.net...
>Can anyone tell me how to find out how frequently an index is used? I have
many indexes in my SIEBEL system that I don't >believe are being used, but I don't know how to tell for sure.

>Thank you.
>--
>Paul LaBarbera
>Randolph, NJ
Received on Wed Jun 04 2003 - 02:10:16 CDT