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.
以下示例显示的是如何检索运行速度缓慢的查询或批查询的显示计划。
