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

Home -> Community -> Mailing Lists -> Oracle-L -> First_Rows hint hangs SQL Statement when using > 56 values present on an IN Clause

First_Rows hint hangs SQL Statement when using > 56 values present on an IN Clause

From: chris blais <bpathways_at_yahoo.com>
Date: Wed, 16 Mar 2005 15:41:12 -0800 (PST)
Message-ID: <20050316234112.73042.qmail@web51708.mail.yahoo.com> 





Hey all,



We can duplicate our 'hang' whenever we have > 56 values in a SQL statement IN Clause.



By removing the first_rows hint, the query works fine.  We're running 9204 Solaris.



Question Anyone seen this before.  Sounds like a limitation with First_rows.......



Much Abliged



    
  
  1.   "Chris" Blais
Bank of America
Vice President -- GCIB Database Technology & Solutions
NC1-004-02-051
desk: 704-387-3010
cell:  720-982-5100






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


Received on Wed Mar 16 2005 - 18:44:39 CST












Original text of this message













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