Index Internals – Rebuilding The Truth December 11, 2007Posted by Richard Foote in Oracle Indexes, Oracle Myths, Oracle Opinion, Index statistics, Richard's Musings, Index Height, Index Internals, Index Rebuild, Index Shrink, Index Coalesce.
The issue of when to rebuild indexes crops up again and again and again. Unfortunately, so do the same incorrect, myth-filled uninspired responses which considering how important and “key” (no pun intended) indexes are to database design and performance generally, is very puzzling indeed.
In the coming days I’ll post why I believe these index related myths simply refuse to go away …
This presentation was originally written several years ago but is still as relevant today as it’s always been.
Recently updated version: Index Internals – Rebuilding The Truth