RE: Index - Blevel
- From: Jonathan Lewis <jonathan@xxxxxxxxxxxxxxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 24 Feb 2015 16:44:43 +0000
No, it means the root block IS the leaf block.
There's only one block in the index; add a few more (indexable) rows to the
table and the block will split, and become a root block with two leaf blocks
below it.
Regards
Jonathan Lewis
http://jonathanlewis.wordpress.com
@jloracle
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx [oracle-l-bounce@xxxxxxxxxxxxx] on behalf
of Paul Harrison [cure@xxxxxxxxxxxxx]
Sent: 24 February 2015 16:02
To: oracle-l@xxxxxxxxxxxxx
Subject: Index - Blevel
Hi ALL,
BLEVEL has a value of 0 and LEAF_BLOCKS has a value of 1. Does this mean the
index consists of the root block and 1 leaf block? The blevel doesn’t
include the root block in its value?
SQL> select index_name,blevel,leaf_blocks
2 from dba_indexes
3 where owner=user
4 and index_name like '%TEST5_LAST_NAME_IDX%'
5 /
INDEX_NAME BLEVEL LEAF_BLOCKS
------------------------------ ---------- -----------
TEST5_LAST_NAME_IDX 0 1
Thanks,
Paul
Other related posts:
