Oracle Database - Blevel Index Statistics

About

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

Formula

<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