• 它会基于存储目录统计中的统计数据而评估可能存取计划执行开销然后选择最低开销的存取计划。

    It estimates the execution cost of each potential access plan based on the statistics data stored in catalog and statistics tables, and selects the one with the lowest cost.

    youdao

  • 可以从以上步骤看到这个优化器基于可用统计信息选择优的存取计划

    As you've seen in the steps above, the optimizer selects the optimal access plan based on available statistics.

    youdao

  • 数据统计信息中的变化引起存取方案选择发生变化,存取方案作为访问期望数据有效方法

    A change in the data statistics can result in a change in the choice of access plan selected as the most efficient method of accessing the desired data.

    youdao

  • 使用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.

    youdao

  • 使用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.

    youdao

$firstVoiceSent
- 来自原声例句
小调查
请问您想要如何调整此模块?

感谢您的反馈,我们会尽快进行适当修改!
进来说说原因吧 确定
小调查
请问您想要如何调整此模块?

感谢您的反馈,我们会尽快进行适当修改!
进来说说原因吧 确定