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
--
//www.freelists.org/webpage/oracle-l


Other related posts: