Figure 8. db2batch - Query execution.
图8 . db 2 batch-查询执行。
Query execution performance stability.
查询执行性能的稳定性。
Db2batch2 - Query execution improvement.
db 2 batch2-查询执行的改进。
Step 1.1: Examine the query execution time.
步骤1.1：检查查询执行时间。
Step 2.1: Examine the query execution plan.
步骤2.1：检查查询执行计划。
Enables or disables a query execution trace.
启用或禁用一个查询执行跟踪。
Figure 11. db2batch - Query execution improvement.
图11 . db 2 batch-查询执行的改进。
This interface is invoked before every query execution.
在执行每个查询前，会调用此接口。
Such rules can significantly reduce query execution time.
这些规则可以显著减少查询执行时间。
Enable the Query Execution Trace on the IBM Cognos 10 system.
在IBMCognos10系统上启用查询执行跟踪。
The query execution plan can be viewed using the db2exfmt tool
这个查询执行计划可以使用db2exfmt工具查看
Illustrates how to interpret a federated query execution plan.
阐释如何解释联邦查询执行计划。
Names of existing indexes that are used for query execution by db2.
DB2用于查询执行的现有索引的名称。
The TRACEONLY option disables the display of query execution results.
TRACEONLY选项禁止显示查询执行结果。
Names of existing indexes that are not used for query execution by DB2
DB2未用于查询执行的现有索引的名称
The following section outlines how to enable the Query Execution Trace.
以下部分概述如何启用查询执行跟踪。
Each connection thread also performs authentication and query execution.
每个连接线程还执行身份验证和查询执行。
A parameterized query binds the value of the parameter before the query execution.
参数化查询在查询执行之前绑定参数的值。
These visualizations include cost based information derived from the query execution.
这些可视化包括来自查询执行的基于成本的信息。
The return operator completes the query execution and returns the query result to the API.
RETURN操作符将完成查询执行，并将查型结果返回到API。
You can analyze the query execution plan output to decide whether or not this is necessary.
您可以分析查询执行计划输出，以确定这是否是必需的。
All SQL comparisons, SQL query execution, and SQL casting takes place in the database code page.
所有SQL比较、SQL查询执行以及SQL类型转换都必须在数据库代码页中进行。
Range producer function to define the search ranges for the spatial index during query execution.
用于定义在查询执行期间空间索引的搜索范围的范围生成器函数。
According to the overall query execution plan, the sub operations are then applied at the sources.
根据总体查询执行计划，将随后对数据源执行各个子操作。
This section illustrates how each partitioning feature contributes to the performance of query execution.
本节阐释每个分区特性对查询执行性能的作用。
The main focus of this group, however, is to avoid full document decompression during query execution.
这类压缩器主要侧重于避免在查询过程中进行完整的文档解压缩。
The DB2 Optimizer is data-partition aware, and only relevant data partitions are scanned during query execution.
DB 2优化器能够感知分区，在执行查询时只扫描相关的数据分区。
REOPT once: query optimization occurs once at query execution time, when the query is executed for the first time.
REOPT ONCE：查询执行中只发生一次查询优化，即在查询第一次执行时。
Section explains and section actuals are very powerful features to investigate problems with a query execution plan.
在研究查询执行计划的问题时，片段解释和片段实绩是非常强大的特性。
The next two columns represent the query execution time in seconds when MQTs are disabled and when MQTs are enabled.
下两列表示禁用MQT和启用MQT时以秒为单位的查询执行时间。
应用推荐