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

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

From: Mercadante, Thomas F <thomas.mercadante_at_labor.state.ny.us>
Date: Thu, 17 Mar 2005 15:13:57 -0500
Message-ID: <C9995D8C5E0DDA4A8FF9D68EE666CE0704AC0366@exchsen0a1ma>

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_at_yahoo.com] Sent: Wednesday, March 16, 2005 6:41 PM
To: oracle-l_at_freelists.org
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

"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 Received on Thu Mar 17 2005 - 15:17:29 CST