I am breaking my head on this issue since long. I have stored procedure in MS SQl and when I try to execute that procedure by providing all the parameters in SQL Query, it takes long time to execute but when I try to directly run the query which is there
in SP it executes in no time. This is affecting my application performance also as we are using stored procedures to fetch the data from DB Server.
View Complete Post