Summary
In this chapter, we examined the role of optimization in query processing and discussed some of the steps that the optimizer goes through in coming up with an execution plan for your queries. Keep in mind that for all but the simplest queries, there are many possible plans that the optimizer could evaluate. In order to be able to optimize in a reasonable amount of time, SQL Server’s optimizer may stop searching for better plans as soon as it finds one that it considers “good enough.” The vast majority of the time, the SQL Server query processor works extremely well. The optimizer generally chooses satisfactory query plans, and most applications just work. For those occasions where problems do arise, we looked at a variety of issues and ...
Get Inside Microsoft® SQL Server™ 2005: Query Tuning and Optimization 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.
