showplan 中文意思是什麼

showplan 解釋
顯示計劃
  1. Exportable showplan and deadlock traces

    可導出的顯示計劃和死鎖跟蹤
  2. You can generate xml showplan output by using the following methods : selecting

    從sql server management studio中的查詢編輯器工具欄中選擇
  3. Saving of traced showplan as xml

    將跟蹤到的顯示計劃另存為xml 。
  4. Perform query analysis by saving showplan results

    通過保存顯示計劃的結果來執行查詢分析。
  5. Graphical display of showplan information showing the logical steps built into the execution plan of a transact - sql statement

    以圖形方式顯示showplan信息,該信息顯示構成transact - sql語句的執行計劃的邏輯步驟。
  6. The following example shows how to retrieve the xml showplan for a slow - running query or batch

    以下示例顯示如何檢索運行速度緩慢的查詢或批查詢的xml顯示計劃。
  7. Set statistics xml also produces showplan output, but in xml format, and executes the query

    除非一個用戶進程終止,否則每個用戶都將無限期等待另一個用戶釋放鎖。
  8. The showplan returned contains correct results

    返回的顯示計劃包含正確的結果。
  9. Statements, to produce a showplan the user must

    語句,若要生成顯示計劃,用戶必須:
  10. Backward compatibility of showplan xml schemas

    顯示計劃xml架構的後向兼容性
  11. B. granting showplan permission to an application role

    B .對應用程序角色授予showplan權限
  12. And each operator in a showplan has a node id

    」 , showplan中的每個運算符都有一個節點id 。
  13. To save the xml showplan to a file, right - click

    若要將xml顯示計劃保存到文件中,請右鍵單擊
  14. The xml schema for showplan is published and available at

    已發布顯示計劃的xml架構,並可在
  15. If an xml showplan is produced, look for a

    如果生成xml顯示計劃,則在
  16. When an except operation is displayed by using the graphical showplan feature in sql server management studio, the operation appears as a

    使用sql server management studio中的圖形顯示計劃功能顯示except運算時,該運算顯示為
  17. The sql management studio showplan feature shows that the relational engine builds the same execution plan for both of these select statements

    Sql management studio的顯示計劃功能可顯示關系引擎為這兩個select語句生成相同的執行計劃。
  18. Dynamic management function returns the showplan in xml format for a transact - sql batch whose query execution plan resides in the plan cache

    Sys . dm _ exec _ query _ plan動態管理函數為transact - sql批查詢返回xml格式的顯示計劃;該批查詢的查詢執行計劃駐留在計劃緩存中。
  19. These operations are called operators and each operator in a showplan has a node id

    這些運算稱為運算符, showplan中的每個運算符都具有一個節點id 。
  20. In microsoft sql server 2005, showplan execution plan output can be generated in xml format by various methods

    在microsoft sql server 2005中,可以通過多種方法以xml格式生成顯示計劃執行計劃輸出。
分享友人