It enables us to look at SQL statements by groups during an interval of time, then tune them as one.
它使我们能够在按组查看一段时间内的sql语句,然后并将它们作为一个整体进行调优。
DB2 Optimization Expert provides an environment to identify and tune poor performing SQL statements.
DB 2OptimizationExpert提供了用来识别和调优表现不佳的sql语句的环境。
To improve SQL efficiency, use equijoins whenever possible. Statements that perform equijoins on untransformed column values are the easiest to tune.
为了提高SQL的效率,尽可能的使用等值连接,没有列转换的语句更容易调整。
Generates a report on the execution path used by the SQL optimizer and the statement execution statistics. The report is useful to monitor and tune the performance of DML statements.
该语句工具主要是研究统计sql语句的执行计划并生成报告,进而对dml语句进行检测和优化。
Generates a report on the execution path used by the SQL optimizer and the statement execution statistics. The report is useful to monitor and tune the performance of DML statements.
该语句工具主要是研究统计sql语句的执行计划并生成报告,进而对dml语句进行检测和优化。
应用推荐