Re: Index - Blevel

From: David Fitzjarrell <oratune_at_yahoo.com>
Date: Tue, 24 Feb 2015 16:55:13 +0000
Message-ID: <1093610511.5257341.1424796913597.JavaMail.yahoo_at_mail.yahoo.com>

BLEVEL 0 is the root level, so there is the root block and one leaf block.  David Fitzjarrell

Principal author, "Oracle Exadata Survival Guide"  

     On Tuesday, February 24, 2015 9:04 AM, Paul Harrison <cure_at_austin.rr.com> wrote:    

 <!--#yiv9785694381 _filtered #yiv9785694381 {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;} _filtered #yiv9785694381 {font-family:Tahoma;panose-1:2 11 6 4 3 5 4 4 2 4;} _filtered #yiv9785694381 {font-family:Consolas;panose-1:2 11 6 9 2 2 4 3 2 4;}#yiv9785694381 #yiv9785694381 p.yiv9785694381MsoNormal, #yiv9785694381 li.yiv9785694381MsoNormal, #yiv9785694381 div.yiv9785694381MsoNormal {margin:0in;margin-bottom:.0001pt;font-size:12.0pt;font-family:"Times New Roman", "serif";color:black;}#yiv9785694381 a:link, #yiv9785694381 span.yiv9785694381MsoHyperlink {color:blue;text-decoration:underline;}#yiv9785694381 a:visited, #yiv9785694381 span.yiv9785694381MsoHyperlinkFollowed {color:purple;text-decoration:underline;}#yiv9785694381 pre {margin:0in;margin-bottom:.0001pt;font-size:10.0pt;font-family:"Courier New";color:black;}#yiv9785694381 p.yiv9785694381MsoAcetate, #yiv9785694381 li.yiv9785694381MsoAcetate, #yiv9785694381 div.yiv9785694381MsoAcetate {margin:0in;margin-bottom:.0001pt;font-size:8.0pt;font-family:"Tahoma", "sans-serif";color:black;}#yiv9785694381 span.yiv9785694381HTMLPreformattedChar {font-family:Consolas;color:black;}#yiv9785694381 span.yiv9785694381BalloonTextChar {font-family:"Tahoma", "sans-serif";color:black;}#yiv9785694381 span.yiv9785694381EmailStyle21 {font-family:"Calibri", "sans-serif";color:#1F497D;}#yiv9785694381 span.yiv9785694381EmailStyle22 {font-family:"Calibri", "sans-serif";color:#1F497D;}#yiv9785694381 span.yiv9785694381EmailStyle23 {font-family:"Arial", "sans-serif";color:windowtext;}#yiv9785694381 .yiv9785694381MsoChpDefault {font-size:10.0pt;} _filtered #yiv9785694381 {margin:1.0in 1.0in 1.0in 1.0in;}#yiv9785694381 div.yiv9785694381WordSection1 {}-->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:55:13 CET