Understanding Stored Procedure Optimization
When working with any computer program, the way it performs is very important. This is even more important when you start working with database procedures that can be executed many times by many users at one time. In this section, we will look at how to make procedures run better, faster, and more efficiently. Along the way, we will see what makes a good stored procedure and what makes a bad one. Learning how to design and code a stored procedure that performs well will allow your application to execute that much faster.
Because many different users execute stored procedures many times a day, the performance of the stored procedures is very important. It is easy to see that if a stored procedure is written ...
Get Sams Teach Yourself Transact-SQL in 21 Days, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
