RE: First_Rows hint

From: Christian Antognini <Christian.Antognini_at_trivadis.com>
Date: Tue, 25 Apr 2006 18:16:43 +0200
Message-ID: <F2C9CCA71510B442AF71446CAE8AEBAF3F5A12@MSXVS04.trivadis.com>

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

Received on Tue Apr 25 2006 - 11:16:43 CDT