真正执行查询，显示查询结果集，显示执行计划，显示统计数据。
Set AUTOTRACE ON: Produces the result set and the explain plan, and lists statistics.
真正执行查询，但不显示查询结果集，显示执行计划，显示统计数据。
Set AUTOTRACE TRACEONLY: Displays the explain plan and the statistics; you will not see the result set, although the statement is executed.
优化后的执行计划输出显示出了极大的提高。
The execution plan output after the optimization showed a significant improvement.
可以根据表名或经过优化后的sql语句中的限定符(quantifier)编号识别表，sql语句显示在由db 2 exfmt工具生成的执行计划中。
You can identify a table by its name or by the quantifier number in the optimized SQL statement shown in the execution plan produced by the db2exfmt tool.
用于取得联邦计划中的异步性的TQ操作符被称作异步表队列（Asynchronous Table Queues），在执行计划中显示为 ATQ。
The TQ operators used to achieve asynchrony in federated plans are called Asynchronous Table Queues, shown in execution plans as ATQ.
执行计划显示72838，这里优化器认为它有良好的过滤芯，所以把它放在一个多个表join的第一位置。显然，它完全错了。
The explain plan shows 72838, optimizer think it has good filtration. So put this JOIN in the first order. Actually, it is totally wrong.
执行计划显示72838，这里优化器认为它有良好的过滤芯，所以把它放在一个多个表join的第一位置。显然，它完全错了。
The explain plan shows 72838, optimizer think it has good filtration. So put this JOIN in the first order. Actually, it is totally wrong.
应用推荐