Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> /*+ORDERED */ - Works Outside of CURSOR but not in ?!
This is an Oracle 8i database. I have attached the /*+ORDERED */ hint to several large queries in hopes of having them run faster - which they did. At least that was the case when I was running the queries in a SQL window outside of my package.
Here's the kicker: I put the queries back into their respective cursors inside my package, and they all hang when I call the program. I haven't waited more than several minutes to see if they will return; anything more than a minute is unacceptable to our users.
Why would the /*+ORDERED */ hint work in a free-standing SQL statement, but not in a cursor? I literally cut and paste the query text back into the program, so there are no differences between the two.
Thanks for anything at all...
B~ Received on Tue May 22 2001 - 19:38:51 CDT