Great note, thanks!Please refer Metalink doc 77574.1 for reference.
- Rebuild the index, coalesce, shrink space, that's it. At the data block level, Oracle does not re-balance the index in real-time, it would be too time-consuming.what control do we,as mere mortals in the presence of the great and mysterious Oz-acle, have over the depth?
Well, the index blocksize makes a big difference in the number of levels, and that's one reason that some shops implement a 32k blocksize, just for indexes that experience multi-block reads:what control do we have over what Oracle decides to use for depth?
So, who do we believe, Morgan's "respected" expertsHi Don
Hey, I never said that!!!Rebuilding an index just because it has parts that are accessed more frequently than other parts of an index sounds like the begining of yet another index related myth to me ...
Gee, ya think so? ; )Don, I would strongly recommend that you not assume metalink is error free ...