showplan
美 
英
例句
This statement is similar to SET SHOWPLAN_TEXT, except that the output is in a format more verbose than that of SHOWPLAN_TEXT.
該語句與SETSHOWPLAN_TEXT相似，但比SHOWPLAN_TEXT的輸出格式更詳細。
Graphical display of Showplan information showing the logical steps built into the execution plan of a Transact-SQL statement.
以圖形方式顯示Showplan信息，該信息顯示構成Transact-SQL語句的執行計劃的邏輯步驟。
Users must also be granted the SHOWPLAN permission for all databases containing referenced objects .
對于包含引用對象的所有數據庫，用戶還必須獲得SHOWPLAN權限。
Neither of these SET statement options check for or require the SHOWPLAN permission.
這些SET語句選項都不檢查SHOWPLAN權限，也不需要SHOWPLAN權限。
Gather Streams logical operators as subtypes , one or more of which can appear in the Showplan output of a query plan for a parallel query .
邏輯運算符，這些子類型中的一個或多個可能會在并行查詢的查詢計劃的顯示計劃輸出中顯示。
SHOWPLAN permission on all databases containing objects that are referenced by the Transact-SQL statements.
對包含Transact-SQL語句所引用對象的所有數據庫的SHOWPLAN權限。
Attribute, the XML Showplan produced will still be correct , but it may not be optimal .
則生成的XML顯示計劃將仍是正確的，但可能不是最佳的。
This is usually the root element of a showplan.
它通常是顯示計劃的根元素。
Identifies the Showplan operators associated with a SQL statement.
標識與SQL語句關聯的Showplan運算符。
SHOWPLAN permission on all databases containing objects referenced by the Transact-SQL statements.
對所有數據庫（包含Transact-SQL語句中所引用的對象）具備SHOWPLAN權限。
When the Showplan Statistics Profile event class is included in a trace, the BinaryData data column must be selected.
當ShowplanStatisticsProfile事件類包括在跟蹤中后，必須選擇BinaryData數據列。
SET SHOWPLAN_TEXT and SET SHOWPLAN_ALL cannot be specified in a stored procedure.
不能在存儲過程中指定SETSHOWPLAN_TEXT和SETSHOWPLAN_ALL。
No Showplan output is generated for the entire batch if any statement execution or permission check errors are encountered.
如果遇到語句執行或權限檢查錯誤，則整個批處理中不會生成Showplan輸出。
SET SHOWPLAN_ALL returns more detailed output intended to be used with programs designed to handle its output.
SETSHOWPLAN_ALL則返回更詳細的輸出，以使專門處理其輸出的程序進行處理。
When the major version number increments, new XML Showplan output may not validate against the old schema.
主版本號增加后，新的XML顯示計劃輸出可能無法按舊的架構進行驗證。
Node IDs in Showplans identify each operation the query optimizer performs when it generates a query execution plan.
Showplan中的節點ID標識查詢優化器在生成查詢執行計劃時執行的每個運算。
Showplan execution plan information can be produced by various ways.
可以通過多種方式生成顯示計劃執行計劃信息。
The additional result set contains the SHOWPLAN_ALL columns for the query and these additional columns.
附加結果集包含查詢的SHOWPLAN_ALL列以及下面的附加列。
The Showplan SET options display no information about encrypted stored procedures or triggers.
ShowplanSET選項不顯示有關加密存儲過程或觸發器的信息。
These operations are called operators and each operator in a Showplan has a Node ID.
這些運算稱為運算符，Showplan中的每個運算符都具有一個節點ID。
SET SHOWPLAN_XML ON allows an XML showplan to be delivered as a single-value result set.
SETSHOWPLAN_XMLON允許將XML的showplan作為一個單值結果集來傳遞。
Identifies Showplan operators within a SQL statement.
標識SQL語句中的Showplan運算符。
Any SET statement can be specified inside a stored procedure, except SET SHOWPLAN_TEXT and SET SHOWPLAN_ALL.
可以在存儲過程中指定除了SETSHOWPLAN_TEXT和SETSHOWPLAN_ALL以外的任何SET語句。
No Showplan information is generated for encrypted stored procedures or for triggers.
對于加密的存儲過程或觸發器，不生成顯示計劃信息。
SET SHOWPLAN_ALL is intended to be used by applications written to handle its output.
SETSHOWPLAN_ALL是供為處理其輸出而編寫的應用程序使用的。
Estimated cost of the Showplan text.
Showplan文本的估計開銷。
SET STATISTICS XML also produces showplan output, but in XML format, and executes the query.
SETSTATISTICSXML會生成XML格式的顯示計劃輸出，并且會執行查詢。
The following example shows how SHOWPLAN permissions are checked for dynamic SQL statements.
下面的示例說明了如何對動態SQL語句執行SHOWPLAN權限檢查。
The Showplan returned contains correct results .
返回的顯示計劃包含正確的結果。
The Bitmap Create operator appears in the showplan output where bitmaps are built.
BitmapCreate運算符出現在創建位圖的顯示計劃輸出中。
No SHOWPLAN permission is checked on the USE master statement.
對USEmaster語句不會檢查SHOWPLAN權限。
No SHOWPLAN permission is checked for the EXEC statement because no Showplan output is generated by it.
EXEC語句不會生成任何Showplan輸出，所以不對該語句執行SHOWPLAN權限檢查。
The SHOWPLAN permission is not required.
但不需要SHOWPLAN權限。
Displays compile time data for Showplan operators.
顯示Showplan運算符的編寫時數據。
Perform query analysis by saving Showplan results.
通過保存顯示計劃的結果來執行查詢分析。
Displays compile time data for Showplan operators in XML format.
以XML格式顯示Showplan運算符的編寫時數據。
Showplan All occurs when a query is executed.
ShowplanAll在執行查詢時發生。
Event is occurring when the query optimizer generates an execution plan, you should also collect a Showplan event class in the trace.
事件的位置，還應該在跟蹤中收集一個Showplan事件類。
The following example shows how to retrieve the XML Showplan for a slow-running query or batch.
以下示例顯示如何檢索運行速度緩慢的查詢或批查詢的XML顯示計劃。
The following example shows how to retrieve the Showplan for a slow-running query or batch.
以下示例顯示的是如何檢索運行速度緩慢的查詢或批查詢的顯示計劃。
