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

Home -> Community -> Usenet -> c.d.o.misc -> SQL statement meanings

SQL statement meanings

From: Peter CCH <petercch.wodoy_at_gmail.com>
Date: 16 Oct 2005 22:49:20 -0700
Message-ID: <1129528160.921316.251900@g49g2000cwa.googlegroups.com> 





I'm not familiar with Oracle query, does anyone know what's the:
"/*+ INDEX(A I_271STATIDX) FIRST_ROWS */" in the query means?



Eg: select /*+ INDEX(A I_271STATIDX) FIRST_ROWS
*/A.NUM,A.SESSIONLOGINDATE,A......


Thanks.


---
Peter CCH


Received on Mon Oct 17 2005 - 00:49:20 CDT












Original text of this message













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