But with the REOPT bind option, the optimizer will generate an access plan against the value provided by the application during runtime, instead of using the generic plan created during bind.
但是通过使用REOPT绑定选项,优化器将会根据应用程序在运行时所提供的值来生成存取计划,而不是使用绑定过程中创建的一般计划。
This article explains distribution statistics, when they are important, and what application developers should consider so that the DB2 optimizer can create efficient access plans.
本文解释什么是分布统计信息、分布统计信息在哪些情况下尤为重要,以及应用程序开发人员应该考虑些什么,才能使DB 2优化器创建有效的访问计划。
In this release, the DBA (as user informix) can create external optimizer directives and apply them to subsequent queries, without changing existing application code.
在该版本中,DBA(作为用户informix)可以创建外部优化器指令,并将其应用于后续的查询,而不需要修改现有的应用程序代码。
应用推荐