[oracle-l] Re: Index block count
- From: "Terrian, Tom (Contractor) (DAASC)" <Tom.Terrian@xxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 27 Jan 2004 16:16:05 -0500
Yes, good question, we analyze each night. There are loads going on all the
time.
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Bobak, Mark
Sent: Tuesday, January 27, 2004 4:12 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: [oracle-l] Re: Index block count
Tom,
You say the blevel is 2. At the risk of stating the obvious, are stats up to
date? Have you loaded any data recently?
Mark J. Bobak
Oracle DBA
ProQuest Company
Ann Arbor, MI
"Imagination was given to man to compensate him for what he is not, and a sense
of humor was provided to console him for what he is." --Unknown
-----Original Message-----
From: Terrian, Tom (Contractor) (DAASC) [mailto:Tom.Terrian@xxxxxxx]=20
Sent: Tuesday, January 27, 2004 4:08 PM
To: 'oracle-l@xxxxxxxxxxxxx'
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.
=20 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.
-------------------------------------------------------------
-------------------------------------------------------------
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:
