If the number of leaf block is 11,000 then how can you get 65484 disk
reads for a fast full scan? Or is that tkprof snippet from before the
coalesce when there were LBLKS: 66653 ?
At 05:08 PM 7/28/2006, Stalin wrote:
LBLKS: 66653 BlVL: 3 CF: 679426 NROWS: 829734 AVG_DATA_BLK/KEY: 2
Coalescing the index got the lblks to 11k and the desired plan however, the performance is still under water. 10046 trace on the sql is
select count(*) from objects where type = 'live'
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.01 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 2 10.39 31.07 65484 69693 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 4 10.40 31.08 65484 69693 0 1
Regards
-- //www.freelists.org/webpage/oracle-l