您要查找的是不是：
- The output of the query plan is not limited in size. 查询计划的输出无大小限制。
- This occurs rarely and only when a query plan has multiple range scans. 这种情况发生的几率很小,仅当查询计划具有多次范围扫描时才会发生。
- The indexed view is used by the query optimizer to produce the query plan. 查询优化器使用该索引视图生成查询计划。
- In other words, you want the query to be parameterized so that a query plan for this kind of query is reused. 换句话说,您想参数化该查询,使此种查询的查询计划可以再次使用。
- The output of the optimizer is a query execution plan, sometimes referred to as a query plan or just a plan. 优化器的输出称为“查询执行计划”,有时也称为“查询计划”或直接称为“计划”。
- Certain operators can cause a section of the query plan to run in serial mode, or the whole plan to run in serial mode. 某些运算符可能会导致查询计划的一部分以串行模式运行,或者导致整个计划以串行模式运行。
- Check the full-text query plan to make sure that the appropriate join plan is chosen. 检查全文查询计划以确保选择了适当的联接计划。
- The Gather Streams operator is only used in parallel query plans. Gather Streams运算符仅用在并行查询计划中。
- Programmatically, you must hold on to the command object that contains the cached query plan. 从编程上讲,必须始终保持包含缓存查询计划的命令对象。
- If a parameter is used in the full-text query, the first-time value of the parameter determines the query plan. 如果全文查询中使用了参数,则该参数的第一时间值决定查询计划。
- For example, if a query plan has a cost factor of 8 and is referenced two times, its age becomes 16. 例如,如果查询计划的成本因子为8并且被引用了两次,则其年变为16。
- Each value you subtract corresponds to a cursor option that was used in the query plan. 所减去的每个值对应于查询计划中所用的一个游标选项。
- USE PLAN can be used to force the query optimizer to use a specified query plan for a query. USE PLAN可以用于强制查询优化器为查询使用指定的查询计划。
- If you notice more than five spills within the same query plan's execution, contact your support professional. 如果您发现同一个查询计划的执行中有五个以上的溢出,请与支持人员联系。
- This query hint virtually disallows direct use of indexed views and indexes on indexed views in the query plan. 实际上,该查询提示不允许在查询计划中直接使用索引视图和直接在索引视图上使用索引。
- A database server can establish a query plan for a view as soon as the view is saved. 数据库服务器可以在保存视图后立即为视图建立查询计划。
- Using this type of query plan, SQL Server supports vertical table partitioning, sometimes called columnar storage. SQL Server利用这种类型的查询计划支持垂直表分区(有时称为分列存储)。
- The query optimizers usually require such estimation of cost to decide an efficient access query plan. 而为了执行查询的最佳化，通常需要估量这种运算的代价，来决定一个有效率的查询计画。
- The following example returns the query plans of all cached triggers. 以下示例返回所有缓存触发器的查询计划。
- Card is short for Cardinality. It is the estimated number of rows that will flow out of a given query plan step. 优化器根据统计信息猜测大致会返回多少行记录。简单理解就是返回的行数。
