The Oracle (tm) Users' Co-Operative FAQ

Which of my indexes are redundant and can be dropped


Author's name: Jonathan Lewis

Author's Email: Jonathan@jlcomp.demon.co.uk

Date written: 2nd Nov 2001

Oracle version(s): n/a

Many systems are loaded with indexes which simply should not exist. But how do you find out on a live system which ones should not be there ?

Back to index of questions


This question is addressed by the following documents:

Author Title/URL Suggested by Referee's comments
Howard Rogers Are my indexes useful ? Jonathan Lewis A short pdf file largely about a new 9i feature. You will need Adobe Acrobat to read this document.
       

.


Further reading:


Back to top

Back to index of questions