RE: Operations that perform multiblock I/O and cluster factor

Ah, sorry, too tired. And it actually wasn't doing a range scan (not now nor in the past), it was doing a index full scan.

STAT #6 id=1 cnt=1000000 pid=0 pos=1 obj=10627 op='TABLE ACCESS BY INDEX ROWID CLUSFAC_DEMO (cr=1001382 r=1000000 w=0 time=96322038 us)' STAT #6 id=2 cnt=1000000 pid=1 pos=1 obj=10629 op='INDEX FULL SCAN IDX_CLF_SCATTERED (cr=1382 r=0 w=0 time=5124467 us)'

> My guess is that the p3=40 is due to the hiddden parameter setting _table_lookup_prefetch_size=40

The guess is correct.

-- 
Riku Räsänen
Kantamestarit OY
www.kantamestarit.fi

--
http://www.freelists.org/webpage/oracle-l