RE: First_Rows hint

From: "Christian Antognini" <Christian.Antognini@xxxxxxxxxxxx>
To: <fred_fred_1@xxxxxxxxxxx>
Date: Tue, 25 Apr 2006 18:16:43 +0200

Fred

>Does anyone know how big the first_rows buffer is? (If I use the hint, how
>does Oracle determine how much data to bring back to me initially?)

Mhmm... Do you mean the optimizer mode FIRST_ROWS?

If yes, it's only an optimization goal, not the size of a buffer.
If no, please, explain what do you mean...


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

Follow-Ups:

Re: First_Rows hint
From: Ghassan Salem

Other related posts:

Browse oracle-l