Posts
543
Comments
466
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
Comments
No comments posted yet.

Post Comment

Title *
Name *
Email
Url
Comment *  
Please add 6 and 2 and type the answer here: