RE: First_Rows hint hangs SQL Statement when using > 56 values pr esent on an IN Clause

Me: "Doctor, it hurts when I do this"
Doctor: "Then don't do that anymore"

Thank you and I'm out.


-----Original Message-----
From: chris blais [mailto:bpathways@xxxxxxxxx] 
Sent: Wednesday, March 16, 2005 6:41 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: First_Rows hint hangs SQL Statement when using > 56 values present
on an IN Clause

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

A. "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
--
http://www.freelists.org/webpage/oracle-l

Other related posts:

  • » RE: First_Rows hint hangs SQL Statement when using > 56 values pr esent on an IN Clause