The following shows how an optimization guideline can specify the runtime degree for a query and affect the query execution.
下面的代码展示了优化指南如何为查询指定运行时等级以及如何影响查询的执行。
To solve that problem, OODT provides transparent access to distributed resources, functionality for data discovery and query optimization, as well as distributed processing and virtual archives.
为了解决那个问题，OODT提供了对分布式资源的透明访问、数据恢复和查询优化功能以及分布式处理和虚拟存档。
The optimizer considers star join optimization when appropriate and decides on star join plan based on cost considerations in order to come up with best execution plan for a star join query.
为了实现星型连接查询的最佳执行计划，优化器在适当的时候会考虑星型连接优化，并根据成本因素来决定星型连接计划。
The discussion focused on a couple of big issues of database design without getting into the details of query optimization and application considerations.
本文着重讨论了数据库设计的两个比较大的问题，而没有深入研究查询优化和应用程序考虑事项的细节。
For the exceptional situations where the optimizer cannot choose an optimal query execution plan, DB2 has added features such as the SELECTIVITY clause and optimization guidelines.
对于优化器不能选择最佳查询执行计划的例外情况，DB 2已经增加了诸如selectivity子句和优化指南之类的特性。
These concurrent connections occur because of asynchrony and do not include connections from the query that were added because of some other optimization e.g.
这些并发连接是指因异步而发生的连接，不包括由于其他优化(例如用于组合操作的数据分发等)而增加查询的连接。
However, optimization decisions are a complex function of various attributes, including the database environment and query characteristics, as well as the data itself.
然而，优化决策是各种属性的复杂函数，这些属性包括数据库环境、查询特征以及数据本身。
Complex query strings, normal form optimization, and the procedural nature of SQL are abstracted via JDO, allowing a development team to focus on the core of their application's persistence needs.
复杂查询字符串、范式优化和SQL的过程性质都通过JDO得以抽象，从而使开发小组可以将精力集中在他们的应用的持久性需求这个核心上。
An operator class is used in conjunction with the access method to specify the operators used for building the index and during query optimization.
将操作符类与访问方法结合使用，可以指定创建索引和优化查询时使用的操作符。
Therefore, most implementations of the data federation pattern focus less on complex transformation capabilities and more on query optimization technologies.
因此，大部分数据联合模式的实现对复杂转换功能的关注相对较少，而更强调查询优化技术。
The following examples are demonstrative of optimization profiles usage in 3 categories, namely, general optimization, query rewrite, and plan optimization.
下面的例子演示了优化概要文件在3类情况下的使用，即常规优化、查询重写和计划优化。
This section covers query optimization and schema optimization.
这一部分包含了查询优化及方案优化。
XML indexing, query optimization, storage management, and other DB2 services help ensure efficiency and strong runtime performance.
xml索引、查询优化、存储管理和其他DB 2服务有助于确保出色的效率和运行时性能。
Optimization guidelines and statistical views are useful features to compensate the access plan evaluations when exceptions in query performance occur.
当查询性能中出现例外情况时，优化指南和统计视图特性对于弥补访问计划估计的不准确性非常有用。
For statistical view, the ENABLE query optimization clause will cause the view, and its associated statistics to be used to improve the query optimization.
对于统计视图，ENABLEQUERY optimization子句将导致该视图以及与之相关联的统计信息被用于改进查询优化。
To speed searches, you may be able to rearrange your tables and, thus, simplify the underlying queries. table and SQL query optimization are highly dependent on your schema and engine.
要加速搜索，您可以重新安排表，并由此简化底层查询表和SQL查询优化高度依赖于模式和引擎。
Query optimization features using hints, explain plans, and profiling.
使用提示、解释计划和分析的查询优化特性。
The "profile Information" section of the db2exfmt output can be used to verify that the correct optimization profile and statement profile have been applied to the current query.
db 2 exfmt输出的“ProfileInformation”部分可以用来检验是否已将正确的优化概要文件和语句概要文件应用到当前的查询。
Those familiar with System I and database query performance analysis and tuning, understand that controlling the optimization goal is a critical step to optimizing performance.
那些熟悉systemi和数据库查询性能分析和调优的人就会理解控制优化目标是优化性能的关键步骤。
Query optimization is crucial in dealing with databases, and UPDATE STATISTICS does just that.
在处理数据库时，查询优化至关重要，而UPDATESTATISTICS正是用于此目的。
If no index is found, then there are no cached tweets, so there is nothing to show and no optimization can be made on the query (and you return a value of 0 to indicate this).
如果没找到任何索引，那么就没有缓存的tweet，所以就没有展示的东西，并且没有可对查询进行的优化(您返回一个0值以指示这一点)。
New query language support (for XQuery), a new graphical query builder (for XQuery), and new query optimization techniques.
新查询语言支持(针对Xquery)、新图形查询构建程序(针对Xquery)和新查询优化技术。
Database query optimization for some of the APIs' operations like querying business process and task related objects (usage of materialized views or stored queries) (see the Resources section).
针对某些API操作(如查询与业务流程和任务相关的对象)的数据库查询优化(使用物化视图或存储查询)(请参见参考资料部分)。
Make sure that the alias and not the base table name is specified in the table attribute in the optimization guideline. For example, to request an XML index access for the following query.
确保优化准则的table属性中没有指定别名和基本表名。
If the query was written by adding a dimension followed by a fact and then another dimension, then the database optimization would include the materialization as necessary.
如果查询的创建是通过先添加维度再添加事实表然后又添加维度的方式构成，那么数据库优化则必须包含实体化。
To improve performance, federation frequently USES caching, materialized query tables (MQTs), and distributed query optimization and execution.
要改进性能，联合需要经常使用缓存、物理查询表(MQT)以及分布式查询优化和执行。
The Senate's IT group moved from single-query fixes to ongoing “preventive” optimization and tuning.
参议院的IT团队从单一查询修复转变为了持续的 “预防性”优化和调优。
Once you realize this, the optimization becomes straightforward: optimize the SLQ query and then transform between the SQL query syntax and the ClearQuest query syntax.
一旦您意识到这一点，那么优化就成为直接的考虑了：优化SQL查询然后在SQL查询与ClearQuest查询语法之间进行转换。
Query Parsing and optimization needs memory. This is usually small to be ignored but certain queries can have very large memory requrement for this step, especially specially crafted ones.
解析查询和优化都需要内存。这些内存通常比较小，可以忽略，不过如果是某些查询在这个步骤中则需要大量内存，尤其是那些设计的比较特别的查询。
Query Parsing and optimization needs memory. This is usually small to be ignored but certain queries can have very large memory requrement for this step, especially specially crafted ones.
解析查询和优化都需要内存。这些内存通常比较小，可以忽略，不过如果是某些查询在这个步骤中则需要大量内存，尤其是那些设计的比较特别的查询。
应用推荐