Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How can I further reduce physical read for this query short of throwing memory at it?
Not sure but the plan says "ALL_ROWS" instead of "CHOOSE". Are you
forcing it through "ALTER SESSION"? Maybe "FIRST_ROWS" is faster (less
gets).
Received on Tue Feb 14 2006 - 13:20:25 CST