文件名称：Inside The SQL Server Query Optimizer
文件大小：2.29MB
文件格式：PDF
更新时间：2021-11-07 04:21:17
SQLServer
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.