Chapter VII.1. Working with the SQL Server Optimizer
Modern, sophisticated relational database management systems like SQL Server rely on core technology known as query optimizers. This key component is tasked with planning the most efficient course to achieve your data goals. To do so, it must weigh many factors, such as table size, indexes, query columns, data distribution metrics, and so on, before it can generate an accurate plan.
In this chapter, you gain a good understanding of SQL Server's Query Optimizer, and you help it do the best possible job for you. We begin by showing you what an optimizer does, using a real-world analogy as a guide. Next, you see how to interpret reports and other guidance offered by the Optimizer. Finally, you discover how to provide the Optimizer with the most up-to-date information so that it can make the best decisions.
Get Microsoft® SQL Server™ 2008 All-In-One Desk Reference For Dummies® 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.
