您要查找的是不是:
- The component that does this is called the query optimizer. 处理此过程的组件称为“查询优化器”。
- This makes sure that the plan guide is used by the query optimizer. 这将确保计划指南可由查询优化器使用。
- Query optimizers estimate only intermediate result sizes. 查询优化器只估计中间结果的大小。
- The query processor ran out of stack space during query optimization. 查询处理器在优化查询时堆栈空间不足。
- The indexed view is used by the query optimizer to produce the query plan. 查询优化器使用该索引视图生成查询计划。
- Selectivity Estimation is the base of spatial database query optimizer. 选择性估计是设计空间数据库查询优化器的基础。
- ON Any missing statistics required by a query for optimization are automatically built during query optimization. 在查询优化期间,将自动生成优化查询需要但缺少的任何统计信息。
- The number of processors that are used by the query optimizer typically provides optimal performance. 查询优化器使用的处理器数量通常能够提供最佳的性能。
- An entry is added to the system catalog to indicate to the query optimizer that such a remote index exists. 一个条目被添加到系统编目中,以向查询优化器表明存在那样的一个远程索引。
- Finally, this discussion of query languages may leave you wondering about a related topic: query optimization. 最后,关于查询语言还有一个相关的主题:查询优化。
- The query optimizer in SQL Server 2005 reliably chooses the most effective index in the vast majority of cases. SQL Server 2005中的查询优化器可在大多数情况下可靠地选择最高效的索引。
- For each query, the query optimizer compares the execution cost of many alternative execution plans. 对于每个查询,查询优化程序将比较多个不同执行计划的执行成本。
- Accurate index information and statistics are fundamental to cost-based decisions in the query optimizer. 准确的索引信息和统计信息是查询优化器中基于成本的决策的基础。
- If one or more query hints causes the query optimizer not to generate a valid plan, error 8622 is raised. 如果一个或多个查询提示导致查询优化器不生成有效计划,则产生8622错误。
- Forces the query optimizer not to recompile a query due to changes in statistics. 强制查询优化器不因统计信息的更改而重新编译查询。
- Forces the query optimizer to relax the estimated recompile threshold for a query. 强制查询优化器对查询放宽估计的重新编译阈值。
- USE PLAN can be used to force the query optimizer to use a specified query plan for a query. USE PLAN可以用于强制查询优化器为查询使用指定的查询计划。
- Specifies that the join order indicated by the query syntax is preserved during query optimization. 指定在查询优化过程中保持由查询语法指示的联接顺序。
- Specifies that the query optimizer use an optimization or locking strategy with this table and for this statement. 指定查询优化器对此表和此语句使用优化或锁定策略。
- The total cost to the query optimizer for executing this operation and all operations preceding it in the same subtree. 查询优化器执行此操作及同一子树内位于此操作之前的所有操作的总开销。