[oracle-l] Re: Index block count

root, branch, leaf and data.
That's 4 blocks.

Jared





"Terrian, Tom (Contractor) (DAASC)" <Tom.Terrian@xxxxxxx>
Sent by: oracle-l-bounce@xxxxxxxxxxxxx
 01/27/2004 01:08 PM
 Please respond to oracle-l

 
        To:     "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
        cc: 
        Subject:        [oracle-l] Index block count


I have a b-tree, unique, local, prefixed, range partitioned index.  The 
blevel
on all of the partitions is 2.  There are no chained/migrated rows in the 
table.
 
I have a query that selects 1 record and only uses the index.  I am not 
sure why
the query uses 4 blocks.  I would think that it would just have to use 1 
for the
branch block and 1 for the leaf block.  Can someone explain it to me?  (I 
have
run the query 8,000 times and the average blocks per execution is 4.1)
Thanks,
Tom

-------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
-------------------------------------------------------------




-------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
-------------------------------------------------------------

Other related posts: