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_at_freelists.org
put 'unsubscribe' in the subject line.
Received on Tue Jan 27 2004 - 15:08:24 CST
