Veteran Oracle DBA Richard Foote recently posted an interesting article/diatribe about the myth of rebuilding Oracle indexes. He states:
There are still many people who think indexes should be rebuilt regularly if they experience lots of DML, that indexes should be rebuilt if they’re have a height greater than some level. . . . [But] most indexes never need to be rebuilt. Never, ever.
It’s an entertaining read, with some lively discussion from readers. On a related note, we also have posted several myth-busting articles you might be interested in. For example,
- Myth: Space is never reused in an index
- Myth: Most discriminating elements should be first
2. Mike Ault’s Oracle myths debunked
- Myth: Indexes and tables do not need to be separated
- Myth: Multiple blocksizes don’t improve performance
Sure, Mike and Tom are no Adam and Jamie (they’ve caused no explosions that I know of), but newbies need to be aware of some of the controversies, half-truths and outright errors percolating in the Oracle community. Do you know of any myths that you’d like to see busted? Let us know!
Have a good week, Tim