RE: Index - Blevel

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Tue, 24 Feb 2015 16:44:43 +0000
Message-ID: <CE70217733273F49A8A162EE074F64D928273620_at_EXMBX01.thus.corp>

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
_at_jloracle

---

From: oracle-l-bounce_at_freelists.org [oracle-l-bounce_at_freelists.org] on behalf of Paul Harrison [cure_at_austin.rr.com] Sent: 24 February 2015 16:02
To: oracle-l_at_freelists.org
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

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Feb 24 2015 - 17:44:43 CET