select /*+ CHOOSE */ column from table etc etc
select /*+ RULE */ column from table etc etc
It could be that ColdFusion is using a different default hint than Oracle
is.
-----Original Message-----
From: Semrau Steven Ctr SAF/IE
Sent: Tuesday, June 08, 2004 10:49 AM
To: CF-Talk
Subject: Trying to solve slow Stored Proc
Okay I'm at a loss here and any suggestions / help is greatly appreciated.
If I run the SP code through SQL+ it will return records almost instantly
(we're talking only 350 records returned here), but via the CF code the
server (web) will either hang FOREVER or return the statement that the
server is busy.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
