-
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.
There are three kinds of lies: Lies, damned lies, and benchmarks...
Unix is user friendly. It's just very particular about who it's friends are.
Oracle DBA
-
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
There are three kinds of lies: Lies, damned lies, and benchmarks...
Unix is user friendly. It's just very particular about who it's friends are.
Oracle DBA
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|