Oracle Database - Blevel Index Statistics


Blevel is the number of branch levels in a Btree index and differs from HEIGHT by one. It does not count the leaf block.


<math>BLEVEL = HEIGHT - 1</math>

How to

Get the value

The value of BLEVEL is found in the normal dictionary tables such as USER_INDEXES after statistics have been gathered.

Powered by ComboStrap