IBM并没有发布优化器如何确定最佳存取路径的真正和深入的详细信息,但优化器是一个基于成本的优化器。
IBM does not publish the actual, in-depth details of how the optimizer determines the best access path, but the optimizer is a cost-based optimizer.
在使用RUNSTATS之后需要重新绑定使用静态SQL的应用程序,这样查询优化器就可以选择新统计信息所给出的最佳存取方案。
Rebind applications that use static SQL after using RUNSTATS so that the query optimizer can choose the best access plan given the new statistics.
然而,您可能仍然希望优化器基于用户传递给查询的值来查找最佳的存取计划。
However, you would still like the optimizer to find the best access plan based on the values that users have passed into the query.
应用推荐