As the application executes, the SQL is compared with the guideline in the active profile.
当应用程序执行时,将SQL与活动的概要文件中的指南相比较。
After adding a connection profile, you can add SQL files and associate them with the connection profiles.
添加了连接配置文件之后,您就可以添加s QL文件,并将其与连接配置文件关联在一起。
When this feature is enabled with its default configuration, the database server tracks the last 1000 SQL statements that ran, along with the profile statistics for those statements.
如果以默认配置启用此特性,数据库服务器会跟踪运行的最后 1000 个SQL语句,并提供这些语句的统计数据。
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。
For example, when an SQL script is run using a Server Profile, the database Settings are applied, but any routine Settings are ignored.
例如,在使用服务器概要文件运行sql脚本时,应用数据库设置,但是忽略所有例程设置。
All SQL statements running in the environment will try to look for matches in the optimization profile that is active, and the matching is designed to be efficient with minimal overhead.
该环境中的所有sql语句将尝试从活动的优化概要文件中查找匹配项,而这种匹配是高效率、低开销的。
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 statement profile section indicates what specific rules apply for individual SQL statements in the STMTKEY element.
statementprofile区段则表明将哪些特定的规则应用于STMTKEY元素中的sql语句上。
A binary representation of the SQL statements is created in a separate serialized profile (.ser file).
sql语句的二进制表示是在一个单独的序列化概要文件(. ser文件)中创建的。
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语句的详细信息。
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语句的详细信息。
应用推荐