最后一个级别是语句级别。
语句级别准则:指定只对特定语句应用的计划属性。
Statement-level guidelines that specify plan attributes that apply to certain statements only.
对于DB 29和动态sql,也可以通过一个全局或语句级别的优化配置来指定REOPT ALWAYS。
With DB2 9 and dynamic SQL, REOPT ALWAYS can also be specified through a global - or statement-level optimization profile.
在语句级别的依赖性分析中,本文还进一步讨论了程序执行期间语句执行的概率信息,并提出了考虑语句执行概率的依赖性分析方法。
At the statement level, then running probability of the statements in run-time is discussed and the method of dependence analysis which concerning the running probability of statements is proposed.
它使用这些信息来确保只对位于同一代码块中相同范围级别的赋值语句执行对齐。
It USES this information to ensure that it aligns only those assignment statements at the same scoping level in the same block of code.
虽然相同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.
在触发器、动态合成语句、标量、表、行函数和方法中不能调用具有访问级别MODIFIESSQLDATA的联邦过程。
Federated procedures with access level MODIFIES SQL DATA cannot be invoked inside triggers, dynamic compound statements, scalar, table, row functions, and methods.
SQLJ提供了独特的使用静态SQL语句进行开发以及在DB2包级别控制访问的能力。
SQLJ provides the unique ability to develop using static SQL statements and control access at the DB2 package level.
使用SETISOLATION在会话级、使用with子句在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.
用户可以为一个工作负载中的每个语句指定重要级别,并指定工作负载中每个语句执行的频率。
Users can rank the importance of each statement in a workload and specify the frequency at which each statement in the workload is to be executed.
如果访问级别是MODIFIESSQLDATA,那么它在触发器、动态合成语句、sql体函数中或在创建保存点时会阻塞,并返回原因码为22的错误SQL 30090。
IF it has MODIFIES SQL DATA, it is blocked in triggers, dynamic compound statements, SQL-bodied functions, or when a save point has been created, and error SQL30090 with reason code 22 is returned.
SQLPL过程包含的sql语句具有一些执行属性,例如隔离级别或优化级别,这些属性只能通过DB2_SQLROUTINE _ PREOPTS注册表变量来覆盖。
SQL PL procedures contain SQL statements that have execution attributes, such as the isolation level or the optimization level that can only be overridden by DB2_SQLROUTINE_PREOPTS registry variable.
如果希望创建一个全局变量表示最高级安全级别,使用下面的语句。
If you want to create a global variable that indicates the maximum security level, use this statement.
对于本场景,已设置了名为pd q .appwide .properties的应用级别属性文件,来为每个应用捕获sql语句。
For this scenario, the application level properties file named pdq.appwide.properties is set to capture the SQL statements for both applications.
为动态sql语句设置重新优化(REOPT)级别。
Setting re-optimization (REOPT) level for dynamic SQL statements.
Python解释器在其最简单的级别,以类似的方式操作,即从程序的顶端开始,然后一行一行地顺序执行程序语句。
The Python interpreter, at its simplest level, operates in a similar manner, starting at the top of a program and sequentially executing program statements in a linear fashion.
语句createTABLE中指定了分区级别的INDEXin子句,或者。
The partition level INDEX in clause is specified in the CREATE TABLE statement, or.
如果有一个包含大量读取操作的工作负载,那么您可能想将隔离级别设置为未提交读取(UR),从而不需要在每个语句中设置隔离级别。
If you have a read-heavy workload, you might want to set isolation to uncommitted read (UR) at the connection level so that you don't have to specify it in each statement.
如果经常要准备语句,那么可以试着调低优化级别。
在应用程序级别上,根据编程语言使用特定语句。
At the application level using specific statements depending on the programming language.
exe压缩myisam表在创建表的语句中使用VALUECOMPRESSION,可以在列或表级别上使用节省空间的行格式来减少空间占用。
Myisampack.exe Compresses myisam table use VALUE COMPRESSION in create table statement to use the space saving row format at the column or table level to reduce space required for a table.
Low:此跟踪级别是默认级别,它捕捉语句统计数据、语句文本和语句迭代器。
Low: This tracing level, which is enabled by default, captures statement statistics, statement text, and statement iterators.
可以使用新的sql语句SETENCRYPTIONPASSWORD实现列级别的加密,提高数据的保密性。
You can use the new SQL statement, SET encryption PASSWORD, to implement column-level encryption and improve the confidentiality of the data.
至于第三种做法,您可以在DataContext级别进行设置(很明显,这会影响每个生成的执行在上下文之上的LINQ toSQL查询语句),使它执行如下命令。
Another third way you could set it at a DataContext level (which, to be clear, would affect every generated LINQ to SQL query executed on that context) would be to execute the command.
也可以创建数据库级别的触发器,将引发这些触发器以响应数据定义语言(ddl)语句。
You can also create database - level triggers that fire in response to data Definition Language (DDL) statements.
当发生严重级别为17、18或19的错误时,虽然可能无法执行特定语句,但仍可以继续工作。
When a level 17, 18, or 19 error occurs, you can continue working, although you might not be able to execute a particular statement.
对于生成日志语句所使用的日志级别。
对于生成日志语句所使用的日志级别。
应用推荐