DB2 provides GUI and command line tools to see explain plan of a query.
DB 2提供的GUI和命令行工具可以用来查看查询的解释计划。
It can also capture queries from SQL cache and produce the explain plan.
它还可以从SQL缓存捕获查询并生成解释计划。
You can use tools to see the explain plan of SQL's in all stored procedures.
可以使用工具查看所有存储过程中的SQL的解释计划。
EXPLAIN and STATISTICS options enable the display of explain plan and statistics information, respectively.
EXPLAIN和STATISTICS选项分别支持显示说明计划和统计信息。
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.
真正执行查询，但不显示查询结果集，显示执行计划，显示统计数据。
By using active and passive management for ORACLE and optimize tools like SQL TRACE EXPLAIN PLAN and ORACLE OPTIMIZER, the query response time is shortened and the efficiency is improved.
通过对Oracle性能的主动和被动管理，以及优化工具SQLTrace、EXPLAIN PLAN和优化器的使用，缩短了数据仓库用户查询响应的时间，提高了查询效率。
By using active and passive management for ORACLE and optimize tools like SQL TRACE EXPLAIN PLAN and ORACLE OPTIMIZER, the query response time is shortened and the efficiency is improved.
通过对Oracle性能的主动和被动管理，以及优化工具SQLTrace、EXPLAIN PLAN和优化器的使用，缩短了数据仓库用户查询响应的时间，提高了查询效率。
应用推荐