Re: How are INDEXES BALANCED?

If you are the Kevin Loney who wrote the Oracle DBA hankbook, I would like to say pretty good book. I did not like the Advanced Oracle Tuning and Administration as I think it had a few too many areas where I disagreed or considered the material too basic.

Interesting point about how Oracle really handles it indexes at the internal level. I was under the impression that Oracle rebalances on inserts but not deletes due to cost. If you take a randomly ordered table and index it, timing the index build it runs much faster than if you build the same index when the rows are already in the indexed column order. This would imply some rebalancing is taking place on inserts. Maybe I need to rerun my test since things change with versions.

.
Mark Powell -- The only advise that counts is the advise that you follow so follow your own advise Received on Tue Sep 16 1997 - 00:00:00 CDT