Re: Identify indexes which are no longer used ?

Short of reviewing all the code (which I have done from time to time), the only way I have found of doing this is to rebuild a suspect index in its own tablespace and then wait a couple of weeks to see if v$filestat shows any signficant read I/O on the file.

--

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

tedchyn_at_yahoo.com wrote in message <7lgl6v$otn$1_at_nnrp1.deja.com>...
>Sir, is there a way identifying obsolete indexes which are no longer
>used ?
>
Received on Thu Jul 01 1999 - 16:20:38 CDT