Oracle Database - Blevel Index Statistics

Card Puncher Data Processing

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.





Discover More
Card Puncher Data Processing
Oracle Database - (B|Balanced) Tree - BTree indexes

The implementation of btree index in the Oracle database. To get to the leaf block to retrieve the first row of a query of the form will take the same number of I/Os regardless of the...
Card Puncher Data Processing
Oracle Database - (Level|Height) Index statistics

The level is also known as theHeight of a B Tree|index or the number of blocks required to go from the root block to the leaf block. Blevel is the number of branch levels and differs from HEIGHT by one...



Share this page:
Follow us:
Task Runner