Chapter 1: Introduction to Query Optimization
The SQL Server Query Optimizer is a cost-based optimizer. It analyzes a number of candidate execution plans for a given query, estimates the cost of each of these plans, and selects the plan with the lowest cost of the choices considered. Indeed, given that the Query Optimizer cannot consider every possible plan for every query, it actually has to find a balance between the optimization time and the quality of the selected plan.
Therefore, it is the SQL Server component that has the biggest impact on the performance of your databases. After all, selecting the right (or wrong) execution plan could mean the difference between a query execution time of milliseconds, and one of minutes, or even hours. Naturally, a better understanding of how the Query Optimizer works can help both database administrators and developers to write better queries and to provide the Query Optimizer with the information it needs to produce efficient execution plans. This book will demonstrate how you can use your newfound knowledge of the Query Optimizer's inner workings and, in addition, it will give you the knowledge and tools to troubleshoot the cases when the Query Optimizer is not giving you a good plan.
Share
Related Documents
  1. SQL Interview Questions (2084)
  2. SQL : Structured Query Language (1681)
  3. SQL Interview Questions with Answers (2388)
  4. ORACLE SQL*Plus (1538)
  5. BACK END TEST GUIDE for SQL (2760)
  6. Simply SQL (2726)
  7. SQL Questions (1475)
  8. PL/SQL for Beginners (1410)
  9. SQL(Oracle) (931)
  10. SQL Server Performance Monitoring Counters and its description (1099)
  11. MS SQL QUERIES (1519)
  12. SQL Complete Reference (920)
  13. SQL SERVER 2008 Interview Questions and Answers (4007)
  14. Predictive Data mining and discovering hidden values of Data warehouse (847)
  15. A Database Testing and QA Roadmap (1663)
  16. Rapid SQL Developer User Guide (944)
  17. SQL practicle introduction (1906)
  18. SQl resource-DB testing (1530)
  19. SQL (1359)
  20. SQL Testing with NUnit (1477)