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.
要查看使用了创建的优化配置文件的查询访问计划，可以结合使用SETCURRENTOPTIMIZATIONprofile语句和SET CURRENTEXPLAINMODEstatement，如下所示。
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 29和动态sql，也可以通过一个全局或语句级别的优化配置来指定REOPT ALWAYS。
Once the profile is enabled, the optimizer automatically matches optimization guidelines to the appropriate statement.
一旦概要文件被启用，优化器将自动将优化准则匹配到对应的语句。
The customer profile data from the HTTP request is passed as a parameter to the update statement; no modifications are needed.
来自HTTP请求的客户个人数据作为参数传递给更新语句；不需要修改。
The resulting page displays a detailed profile of an SQL statement execution, selected through drill down.
产生的页面显示sql语句的详细执行情况。
When specified, you can include one or more statement profiles using STMTPROFILE tags, and include guidelines that apply to specific SQL queries. Each statement profile consists of.
在指定语句概要文件部分后，可以使用STMTPROFILE标记包含一个或多个语句概要文件，并包含适用于特定SQL查询的准则。
The "profile Information" section of the db2exfmt output can be used to verify that the correct optimization profile and statement profile have been applied to the current query.
db 2 exfmt输出的“ProfileInformation”部分可以用来检验是否已将正确的优化概要文件和语句概要文件应用到当前的查询。
The statement profile section is optional.
语句概要文件部分（statement profile section）是可选的。
If a guideline is updated, or deleted from the table, then it is necessary to refresh the cache by issuing the FLUSH OPTIMIZATION PROFILE cache statement, so it can be used.
如果从这个表中更新或删除一个指南，那么需要通过发出FLUSHOPTIMIZATIONPROFILEcache语句更新缓存，使之可以被使用。
The statement profile section indicates what specific rules apply for individual SQL statements in the STMTKEY element.
statement profile区段则表明将哪些特定的规则应用于STMTKEY元素中的sql语句上。
From the SQL List screen, you can choose a session of interest and click on Drill Down to get a detailed profile about this particular SQL statement.
在SQLList屏幕上，可以选择感兴趣的会话并单击Drill Down，从而获得关于此sql语句的详细信息。
Our league is of the belief that players who perform for their national team add profile to our league and it is a great statement for the quality of playing Major League Soccer.
我们的联盟相信为国家队效力的球员会增加我们联赛的知名度，这是对大联盟足球竞技水平的充分说明。
Our league is of the belief that players who perform for their national team add profile to our league and it is a great statement for the quality of playing Major League Soccer.
我们的联盟相信为国家队效力的球员会增加我们联赛的知名度，这是对大联盟足球竞技水平的充分说明。
应用推荐