The Design of Database Query Optimization.
在数据库的查询优化设计方面。
Provides an overview of federated query optimization.
对联邦查询优化作一个概述。
This will have an undesirable effect on query optimization.
这对于查询的优化有着不良的影响。
This section covers query optimization and schema optimization.
这一部分包含了查询优化及方案优化。
This will have an undesirable effect on query optimization .
这对于查询的优化有着不良的影响。
Informational constraints can be a great aid to query optimization.
信息约束可以很好地辅助查询优化。
Query optimization features using hints, explain plans, and profiling.
使用提示、解释计划和分析的查询优化特性。
Query optimization concerns how to improve the performance of slow queries.
查询优化涉及到了怎样改进慢速查询的问题。
Query optimization is the critical technique of parallel database systems.
查询优化是并行数据库系统的核心技术。
Meanwhile, query optimization tactics focused on minimizing page fetches wherever possible.
与此同时，查询优化策略注重尽可能减少页面读取。
Query optimization is crucial in dealing with databases, and UPDATE STATISTICS does just that.
在处理数据库时，查询优化至关重要，而UPDATESTATISTICS正是用于此目的。
Query rewriting technology based on view is an important technology of the query optimization.
基于视图的查询重写技术是优化查询的一个重要技术。
You can defer query optimization until input variables are known at runtime with the REOPT guideline.
可以使用REOPT指南，将查询优化推迟到运行时输入变量已知的时候。
The REOPT bind option defers query optimization until input variable values are available at OPEN time.
REOPT绑定选项将查询优化推迟到OPEN时有可用输入变量的时候。
Internal query processor Error: The query processor ran out of stack space during query optimization.
内部查询处理器错误：在查询优化过程中，查询处理器用尽了堆栈空间。
Large buffer pools also have an effect on query optimization, since more of the work can be done in memory.
大型缓冲池还会对查询优化产生影响，因为更多的工作可在内存中完成。
The RUNSTATS utility updates statistics in the system catalog tables to help with the query optimization process.
RUNSTATS实用程序用于更新系统目录表中的统计信息，以帮助查询优化过程。
REOPT once: query optimization occurs once at query execution time, when the query is executed for the first time.
REOPT ONCE：查询执行中只发生一次查询优化，即在查询第一次执行时。
Now let us discuss the issue with the query optimization for the objects which are configured for second level cache.
现在我们来谈谈关于二级缓存的查询优化问题。
You can specify for example what REOPT options to use, or what MQT table to consider or what query optimization to use.
例如，可以指定使用哪个REOPT选项，使用哪个mqt表，或者使用什么样的查询优化。
The 'DISABLE QUERY OPTIMIZATION' clause may be used to prevent the optimizer from considering use of a particular MQT.
DISABLEQUERY OPTIMIZATION'子句可以用来防止优化器考虑使用特定的MQT。
New query language support (for XQuery), a new graphical query builder (for XQuery), and new query optimization techniques.
新查询语言支持(针对Xquery)、新图形查询构建程序(针对Xquery)和新查询优化技术。
The federation server must also provide query optimization capabilities in order to respond to the request most efficiently.
联合服务器还必须提供查询优化功能，以最高效地响应请求。
The runstats utility can be used to update statistics in system catalog tables to facilitate the query optimization process.
可以使用runstats实用程序来更新系统编目表中的统计信息，使查询优化过程更容易一些。
The query optimization class is used to direct the optimizer to use different degrees of optimization when compiling SQL queries
查询优化类用于在编译SQL 查询时指导优化器使用不同的优化级别。
Query optimization technology in DB2 9.7 provides increased efficiency for processing queries against relational views of XML data.
DB 2 9.7中的查询优化技术能够提高针对XML数据的关系视图的查询处理效率。
XML indexing, query optimization, storage management, and other DB2 services help ensure efficiency and strong runtime performance.
xml索引、查询优化、存储管理和其他DB 2服务有助于确保出色的效率和运行时性能。
As join operation to relational database, structural join order selection is at the heart of query optimization in an XML database.
和关系数据库中的连接运算一样，结构连接顺序的选择是XML数据库查询优化的核心。
The value of the register in turn determines what types of refresh deferred materialized query tables will be used during query optimization.
注册表的值又确定在查询优化期间将使用何种类型的刷新延迟物化查询表。
If you want to disable the usage of the constraints by the SQL compiler, you can use the disable QUERY OPTIMIZATION clause. For example.
如果您想通过编译器禁用约束，那么可以使用DISABLEQUERY optimization子句。
应用推荐