showplan 中文意思是什麼
showplan
解釋
顯示計劃-
Exportable showplan and deadlock traces
可導出的顯示計劃和死鎖跟蹤 -
You can generate xml showplan output by using the following methods : selecting
從sql server management studio中的查詢編輯器工具欄中選擇 -
Saving of traced showplan as xml
將跟蹤到的顯示計劃另存為xml 。 -
Perform query analysis by saving showplan results
通過保存顯示計劃的結果來執行查詢分析。 -
Graphical display of showplan information showing the logical steps built into the execution plan of a transact - sql statement
以圖形方式顯示showplan信息,該信息顯示構成transact - sql語句的執行計劃的邏輯步驟。 -
The following example shows how to retrieve the xml showplan for a slow - running query or batch
以下示例顯示如何檢索運行速度緩慢的查詢或批查詢的xml顯示計劃。 -
Set statistics xml also produces showplan output, but in xml format, and executes the query
除非一個用戶進程終止,否則每個用戶都將無限期等待另一個用戶釋放鎖。 -
The showplan returned contains correct results
返回的顯示計劃包含正確的結果。 -
Statements, to produce a showplan the user must
語句,若要生成顯示計劃,用戶必須: -
Backward compatibility of showplan xml schemas
顯示計劃xml架構的後向兼容性 -
B. granting showplan permission to an application role
B .對應用程序角色授予showplan權限 -
And each operator in a showplan has a node id
」 , showplan中的每個運算符都有一個節點id 。 -
To save the xml showplan to a file, right - click
若要將xml顯示計劃保存到文件中,請右鍵單擊 -
The xml schema for showplan is published and available at
已發布顯示計劃的xml架構,並可在 -
If an xml showplan is produced, look for a
如果生成xml顯示計劃,則在 -
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運算時,該運算顯示為 -
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語句生成相同的執行計劃。 -
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格式的顯示計劃;該批查詢的查詢執行計劃駐留在計劃緩存中。 -
These operations are called operators and each operator in a showplan has a node id
這些運算稱為運算符, showplan中的每個運算符都具有一個節點id 。 -
In microsoft sql server 2005, showplan execution plan output can be generated in xml format by various methods
在microsoft sql server 2005中,可以通過多種方法以xml格式生成顯示計劃執行計劃輸出。
分享友人