Re: index never used

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Wed, 06 Feb 2002 22:59:23 +0000
Message-ID: <3C61B54B.1D5B@yahoo.com>

franz mueller wrote:
>
> Hi,
>
> I have a DB, that has a huge amount of indices. I am would bet that
> 80% of them have been added by people not knowing what they are doing,
> and therefore are never used. How can I monitor those indices. I use
> 8.x
>
> Thank you
> Franz

There is a (rudimentary) script on my site which runs explain on every SQL in memory - you then scan the plan table for index objects.

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."

Received on Wed Feb 06 2002 - 16:59:23 CST