Oracle Database - Blevel Index Statistics

> Database > Oracle Database

1 - 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.


3 - Formula

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

4 - How to

4.1 - Get the value

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