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

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.

主站蜘蛛池模板: 宁陵县| 江北区| 千阳县| 兴化市| 新巴尔虎右旗| 灌阳县| 刚察县| 扬州市| 沾化县| 井研县| 若尔盖县| 南开区| 准格尔旗| 兰西县| 华安县| 称多县| 华亭县| 三原县| 昆明市| 获嘉县| 旬邑县| 宜丰县| 凤城市| 宁蒗| 拉萨市| 鄱阳县| 宁强县| 高安市| 大方县| 丹阳市| 增城市| 岢岚县| 黔西县| 太仆寺旗| 会泽县| 永定县| 兰考县| 金昌市| 阜新| 白河县| 收藏|