Oracle Database - Blevel Index Statistics

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.

Data Science
Data Analysis
Data Science
Linear Algebra Mathematics

Powered by ComboStrap