官术网_书友最值得收藏!

Understanding the query optimization workflow

Now it's time to take a deeper look at how SQL Server creates optimized query execution plans. As mentioned in Chapter 2Understanding Query Processing, this is the second phase of query processing, and for the most part only Data Manipulation Language (DML) statements undergo query optimization. The query optimization process is defined by the following cumulative stages:

  • Trivial Plan
  • Exploration which in turn, includes three phases in itself:
    • Transaction processing
    • Quick plan
    • Full optimization

In the Exploration stage, what differentiates between the several phases is the increasing sets of rules applicable to each one as the search for a good-enough query plan progresses. Users can learn about the optimization level of a given query execution plan by looking at the properties of that plan. The following sections include sample execution plans to illustrate the concepts covered here. Query execution plans will be discussed in more detail in Chapter 4Exploring Query Execution Plans.

主站蜘蛛池模板: 迁西县| 扶风县| 葫芦岛市| 工布江达县| 吉木萨尔县| 大厂| 八宿县| 青神县| 定陶县| 乌拉特前旗| 阿勒泰市| 连平县| 盖州市| 大关县| 阜新市| 盘山县| 孝感市| 徐汇区| 曲靖市| 无锡市| 云浮市| 方山县| 土默特右旗| 朝阳区| 鄄城县| 台江县| 曲周县| 溧阳市| 泗阳县| 登封市| 延寿县| 汪清县| 乡宁县| 石楼县| 石景山区| 汾西县| 凤庆县| 德州市| 邵东县| 东阿县| 通州市|