Posts
1150
Comments
891
Trackbacks
1
Slow Stored Procedure Execution

Suppose you have a stored procedure that runs fine in one environment, but slower in another.  You check to make sure all the underlying indexes exist.  You recompile it a couple of times.  Still, it doesn't perform as it should.

Try:

Update Statistics tablename

posted on Wednesday, December 28, 2005 5:03 PM Print
Comments
No comments posted yet.

Post Comment

Title *
Name *
Email
Url
Comment *  
Please add 5 and 4 and type the answer here: