Rebuild btree index myth ?

This PDF by Richard Foote uses quotes from Burleson and Niemec which he disagrees with and considers 'myths'.

Rebuilding The Truth

http://www.actoug.org.au/Downloads/o..._internals.pdf

The vast majority of indexes do not require rebuilding

Oracle B-tree indexes can become “unbalanced” and
need to be rebuilt is a myth

Deleted space in an index is “deadwood” and over time
requires the index to be rebuilt is a myth

If an index reaches “x” number of levels, it becomes
inefficient and requires the index to be rebuilt is a myth

If an index has a poor clustering factor, the index needs
to be rebuilt is a myth

To improve performance, indexes need to be regularly
rebuilt is a myth

unless you have a question in there - its all correct

Jonathan Lewis just wrote something on that also ... http://www.jlcomp.demon.co.uk/indexes_i.html

And I thought the war was over.

Quote:

---

Originally posted by simply_dba
And I thought the war was over.

---

It's been downgraded to a Police Action.

So, everybody is doing the "post mortem" of their own