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 2 Optimization Expert提供了用来识别和调优表现不佳的sql语句的环境。
To improve SQL efficiency, use equijoins whenever possible. Statements that perform equijoins on untransformed column values are the easiest to tune.
为了提高SQL的效率,尽可能的使用等值连接,没有列转换的语句更容易调整。
应用推荐