AUTOTRACE

You surely came across these two columns while going through DBA_% or Oracle documentation. AVG_LEAF_BLOCKS_PER_KEYAVG_DATA_BLOCKS_PER_KEY They are to be spotted “here and there”. I bet though you may tend to skip them as not important or.. not really well understood, so not important.I will make an attempt to demystify them and show how valuable they…