A recent enhancement to DB2 for I 6.1 makes it possible to understand the optimizer use at the SQL statement level within the SQL Performance Monitor.
DB 2fori 6.1最近的一个增强使得理解在SQL性能监视器中sql语句级使用优化器成为可能。
ISOLATION level is set at the session level using set ISOLATION, set at the SQL statement level using the WITH clause or set at the database level using a database Configuration parameter.
使用SETISOLATION在会话级、使用with子句在sql语句级或使用数据库配置参数在数据库级设置隔离级别。
Although different access paths for the same SQL statement produce the same result set, they most likely do not perform the task with the same level of performance.
虽然相同sql语句的不同访问路径会产生相同的结果集，但是它们很有可能不会通过同样的性能级别来执行任务。
At some level, the SQL UPDATE statement is the union of the SQL INSERT and DELETE statements, because you must select rows to modify as well as specify how to modify them.
在某种程度上，SQLupdate语句是SQLINSERT和delete语句的联合，因为您必须选择要修改的行，还必须指定如何修改它们。
Information about all SQL statements executed before the lock-timeout event in the participating transactions, such as statement text, isolation level used, order of execution, and so on.
在参与事务中的锁超时事件前执行的所有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。
With Query Annotation, you can format the SQL statement for improved readability and navigation and see which statistics are being used at the table and column level.
可以使用QueryAnnotation控制sql语句的格式以提高可读性，还可以查看表级和列级使用的统计数据。
The SQL statement will select and group on the Li's level keys to ensure that the query is at the correct level of detail for Di.
SQL语句将按照 Li的级键进行选择和分组，从而确保查询采用 Di的正确细节级。
At a high level, you see the familiar "update... set... where..." syntax of an SQL update statement.
SQLupdate语句的总体结构仍然是大家熟悉的“update…set…。where…”语法。
You can use the new SQL statement, SET encryption PASSWORD, to implement column-level encryption and improve the confidentiality of the data.
可以使用新的sql语句SETENCRYPTIONPASSWORD实现列级别的加密，提高数据的保密性。
At a minimum, the set of level key attributes for Li need to be in the SQL statement.
sql语句中至少需要有Li的级键属性。
At a minimum, the set of level key attributes for Li need to be in the SQL statement.
sql语句中至少需要有Li的级键属性。
应用推荐