It may have something to do with parameters. What if any data type are the parameters?
-----Original Message----- From: Steve Abaffy [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 2:23 PM To: ActiveServerPages Subject: OT: SQL Query runs way faster in Query Window then as Stored Procedure Hello, I was just wondering if anybody knew why the exact same piece of SQL would run faster in the Query Analyzer window than it does as a stored procdure. I mean in the query window it takes 10 seconds and as a stored procedure it takes 9 minutes and 21 seconds????? Any help in this are would be greatly appreciated. --- You are currently subscribed to activeserverpages as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
