RE: First_Rows hint hangs SQL Statement when using > 56 values pr esent on an IN Clause
- From: "Mercadante, Thomas F" <thomas.mercadante@xxxxxxxxxxxxxxxxx>
- To: "'bpathways@xxxxxxxxx'" <bpathways@xxxxxxxxx>, oracle-l@xxxxxxxxxxxxx
- Date: Thu, 17 Mar 2005 15:13:57 -0500
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
--
//www.freelists.org/webpage/oracle-l
--
//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
