I have a white paper on my Web site ( http://www.peasland.net) titled, "Knowing when to rebuild indexes." It even contains a script to dynmically determine which indexes need to be rebuilt. Please read this paper.
Dig Deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.