Re: Q: Identify indexes which are no longer used ?

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sun, 4 Jul 1999 21:03:34 +0100
Message-ID: <931118865.7423.0.nnrp-12.9e984b29@news.demon.co.uk>

True, but for the once a year/quarter and possibly even month, it is arguably the case that the process that uses the index should build it, use it, and drop it.

Luckily all the best people document the reason for the existence of their indexes and maintain an object to process cross-reference, ;)

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

michael_bialik_at_my-deja.com wrote in message <7lkjbk$34f$1_at_nnrp1.deja.com>...
>Still you have a problem of once-in-period ( once a
>week/month/quater/year ) usage of that index.
>
Received on Sun Jul 04 1999 - 15:03:34 CDT