SQL PL过程包含的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.
将CURRENT REFRESH AGE特殊注册表设置为值any使得在当前连接上下文中,将为优化考虑所有刷新延迟的MQT。
Setting the current refresh AGE special register to the value ANY enables all refresh deferred MQTs to be considered for optimization in the context of the current connection.
例如,为了指示优化器应该为优化考虑所有维护表类型,您应该像下面这样设置特殊注册表
For example, to indicate to the optimizer that all maintained table types should be considered for optimization, you would set the special register as follows
应用推荐