Summary
The following are some important notes to remember when working with the query optimizer:
SQL Server's query optimizer has been significantly improved from previous versions. New optimization techniques result in faster query response times.
Query optimization is part science, part luck. What works on one query might not work on another query. Try different techniques until you get the performance you expect.
Use the Index Tuning Wizard, Showplan, Statistics I/O, Stats Time, and SQL Profiler tools to help tune a query.
If you want to maximize OLTP performance, do everything you can to prevent a table scan on a large table.
A good DBA knows how the SQL Server optimizer works. This knowledge enables the DBA to turn an agonizingly slow query ...
Get Microsoft® SQL Server™ 2000 DBA Survival Guide, 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.
