What Indexes are being used?

From: Bruce Mackay <bmackay_at_bmm.com.au>
Date: Mon, 27 Mar 2000 11:58:08 +1000
Message-ID: <8bmf6e$nqp$1@perki.connect.com.au>

Hi everyone,

I've inherited support of a system with many indexes, probably too many indexes!

I've looked around without success for a resource to help identify which are being used in normal production.

Does anyone know of a likely resource that can help in this situation? Helpful information would include number of times an index is 'used' as opposed to being updated since ?? (ie. re-starting the instance).

Many thanks in advance.

Bruce Mackay, BMM Pty Ltd Received on Sun Mar 26 2000 - 19:58:08 CST