Santosh Pradhan wrote:It is unsubstantiated Urban Legend that say Index should be rebuilt when BLEVEL=4.
we have table gen_1
We observed that the blevel of index on this table has reached to 4 and when we rebuild an index it goes to blevel 3 .
But when i gather statts on this table ,the blevel for that same index goes to 4 automatically .
3-4 time i observed this ...
Can anyone tell me , whyyyy??
sb92075 wrote:That is true - but in this case the OP says that when he rebuilds the index the level drops from 4 to 3, and that is almost a sufficient argument to do the rebuild if his observation is correct. However he could do with a better measure of the efficiency of his index and how much (benefit if any) the rebuild introduces.
It is unsubstantiated Urban Legend that say Index should be rebuilt when BLEVEL=4.