To view the query access plan using the optimization profile created, the SET CURRENT optimization profile statement can be used in combination with the SET CURRENT EXPLAIN MODE statement, as follows.
要查看使用了创建的优化配置文件的查询访问计划,可以结合使用SET CURRENT OPTIMIZATION profile语句和SET CURRENT EXPLAIN MODE statement,如下所示。
If you need to affect multiple queries, include multiple statement profiles in a single optimization profile.
如果需要影响多个查询,可在一个优化概要文件中包含多个语句概要文件。
With DB2 9 and dynamic SQL, REOPT ALWAYS can also be specified through a global - or statement-level optimization profile.
对于DB 2 9和动态sql,也可以通过一个全局或语句级别的优化配置来指定REOPT ALWAYS。
应用推荐