Stored procedure Vs SSRS table
I'm getting different experience here
I've a stored procedure and while I'm trying to execute procedure in query window of SQL Server 2008 it is taking around 5 to 6 mins for me to execute (Because it is having multiple subqueries)
But the same p开发者_C百科rocedure I've executed through SSRS table. I'm getting results in SSRS table with in less than a minute.
How it is possible? Did SSRS handling this time internally? or any other reason?
Thank you
精彩评论