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:

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