Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: First_Rows hint

Re: First_Rows hint

From: Dennis Williams <oracledba.williams_at_gmail.com>
Date: Tue, 25 Apr 2006 12:38:53 -0500
Message-ID: <de807caa0604251038x5df4f7d4u8091f45d89e16350@mail.gmail.com> 





Fred,



Perhaps you are thinking of the newer FIRST_ROWS_n hint, which you should be
using now. To repeat what Christian and Salem have stated, no buffer is
allocated, it just influences the optimizer behavior.



Dennis Williams


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


Received on Tue Apr 25 2006 - 12:38:53 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US