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

Home -> Community -> Usenet -> c.d.o.server -> FIRST_ROW USAGE

FIRST_ROW USAGE

From: <yarch_at_hotmail.com>
Date: Fri, 11 Jun 1999 18:40:24 GMT
Message-ID: <7jrl6m$n1g$1@nnrp1.deja.com> 





Hi,


I've been given code that looks like


this



SELECT /*+ FIRST_ROW */



...


FROM



WHERE


what exactly does this do in order to improve efficiency?
I'm familiar with /*+ CACHE */  Is it something similiar?
Thanks,


Mike Yarcheski


yarch_at_hotmail.com




Sent via Deja.com http://www.deja.com/



Share what you know. Learn what you don't.
Received on Fri Jun 11 1999 - 13:40:24 CDT












Original text of this message













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