execution plan 中文意思是什麼

execution plan 解釋
具體實施方案
  • execution : n 1 實行,履行,執行;貫徹。2 執行死刑;強制執行;執行命令。3 作成,完成;簽名蓋印使法律文件生效...
  • plan : n 1 計劃,設計,方案,規劃;方法;進程表;時間表。2 圖,圖面;平面圖,設計圖;示意圖;圖表;(街...
  1. When a query on the relational views is issued, it is repeatedly rewritten using the rules. this process generates number of navigation plans to compute the query ; the cost of these plans is then estimated based on a simple cost model that takes network accesses as the primary cost parameter. in this way, an efficient execution plan is selected for processing the query

    當根據關系視圖發出一個查詢時,它被重復的使用重寫規則來重寫,這個過程產生大量的導航方案來運算查詢。這些方案的代價是根據代價模型來評估的。代價模型是用網路訪問作為原始的代價參數。
  2. In design flow modeling, a new design flow model definition method based on object oriented colorful petri net is put forward. in sub _ task dispatching, the task database, the task dispatch algorithm, the task dispatching time and its amending algorithm, the task dispatching execution plan etc. are designed. in version management, the version model of design object is built and the relationship between the linkers in dfms model and the version model about design objects is studied

    在相關的關鍵技術研究中,提出了一套包括通信模型的建立、通信原語的設計、通信服務器的設計等內容在內的被動式協同設計通信方案;設計了一種基於面向對象有色petri網技術的設計流程模型定義方法;提出了一種基於調度時間和資源狀況的子任務調度方案,並完成了任務數據庫的設計、子任務調度演算法的設計、子任務調度時間及其修正演算法的設計和子任務調度實施方案的設計等工作;建立了設計對象的版本模型,研究了設計流程模型的各種連接器與設計對象各種版本間的對應關系。
  3. Sql server compiles the statements of a batch into a single executable unit, called an execution plan

    Sql server將批處理的語句編譯為單個可執行單元,稱為執行計劃。
  4. A statistics update is initiated whenever the statistics used in a query execution plan fail a test for current statistics

    每當查詢執行計劃中使用的統計信息沒有通過針對當前統計信息的測試時就會啟動統計信息更新。
  5. Because the sql server 2005 query optimizer typically selects the best execution plan for a query, we recommend that hints, including

    由於sql server 2005查詢優化器通常為查詢選擇最優執行計劃,因此建議只將提示包括
  6. Because the sql server 2005 query optimizer typically selects the best execution plan for a query, we recommend that hints, including query hint, be used only as a last resort by experienced developers and database administrators

    由於sql server 2005查詢優化器通常為查詢選擇最優執行計劃,因此建議只將提示(包括< query _ hint > )用作經驗豐富的開發人員和數據庫管理員的最終手段。
  7. Because the sql server 2005 query optimizer typically selects the best execution plan for a query, we recommend that hints, including table hint, be used only as a last resort by experienced developers and database administrators

    由於sql server 2005查詢優化器通常為查詢選擇最優執行計劃,因此我們建議,只有在萬般無奈的情況下才由經驗豐富的開發人員和數據庫管理員使用提示(包括< table _ hint > ) 。
  8. Cached values exist because the sql server execution plan determines that the values for some variables will not be dynamically loaded for each statement execution or reference

    緩存值之所以存在,是因為sql server執行計劃確定不會為每個語句執行或引用動態加載一些變量的值。
  9. Out - of - date or missing statistics are indicated as warnings table name in red text when the execution plan of a query is graphically displayed using sql server management studio

    在使用sql server management studio以圖形方式顯示查詢的執行計劃時,過時或缺少的統計信息將予以警告顯示(表名稱以紅色文本顯示) 。
  10. For these queries, sql server inserts exchange operators into the query execution plan to prepare the query for parallel execution

    對于這些查詢, sql server會將交換運算符插入查詢執行計劃中,以便為查詢的并行執行做準備。
  11. When any sql statement is executed in sql server 2005, the relational engine first looks through the procedure cache to verify that an existing execution plan for the same sql statement exists

    在sql server 2005中執行任何sql語句時,關系引擎將首先查看過程緩存中是否有用於同一sql語句的現有執行計劃。
  12. For data consistency maintenance, mork s rules are extended for governing the use of updategrams and boosters. the new rule system can be used to optimize the execution plan

    在pdms中一個視圖可能涉及到多個表的連接,根據該應用需要我們在數據一致性維護方面擴展了mork應用updategrams和booster的規則系統。
  13. Firstly, the system r style dynamic programming procedure ( and the specific heuristic rule ) is used to determine the join order of the relations. after that, the expensive predicates are placed in the operator tree ( or execution plan ) according their rank values with respect to joins

    它首先利用systemr中的動態規劃優化演算法和啟發式規則為連接運算產生連接次序,在此基礎上,根據選擇條件的rank值,將它放置到執行規劃中的適當位置。
  14. Graphical display of showplan information showing the logical steps built into the execution plan of a transact - sql statement

    以圖形方式顯示showplan信息,該信息顯示構成transact - sql語句的執行計劃的邏輯步驟。
  15. Develop and supervise project execution plan, in process audit

    制定並監督項目執行計劃,過程審查。
  16. The execution plan in xml format for the slow - running query or batch is contained in the

    運行速度緩慢的查詢或批查詢的xml格式的執行計劃包含在
  17. When the query optimizer analyzes a query to determine the best execution plan, it automatically generates information about indexes that would improve query performance even if the indexes do not exist

    當查詢優化器分析查詢以確定最佳執行計劃時,即使沒有索引,優化器也能自動生成可提高查詢性能的索引的相關信息。
  18. In the previous example, if customer. customer num and orders. customer num are not indexed, dynamic hash join would be chosen by the optimizer as the best execution plan. the optimizer will choose nested - loop joins if

    在前一個實例中,如果customer . customer _ num和orders . customer _ num都沒有被索引,那麼優化器將選擇動態哈希連接來作為最佳的執行計劃。
  19. This makes it possible to get query execution plan in the real production environment

    這使您可以在真正的生產環境中獲取查詢執行計劃。
  20. Include actual execution plan in the query output

    在查詢輸出中包括實際執行計劃
分享友人