What if you know your OLTP searches should use the same execution plan for different binding values?

要是你知道你的OLTP搜索对不同绑定值应该使用相同执行计划又该怎么办呢？

youdao

The binding you choose depends on how you plan to access the component.

所选择的绑定取决于计划如何访问组件。

youdao

The reason for using binding parameters is to ask the database to parse your SQL once and reuse the generated execution plan for subsequent repeat requests, which saves both CPU time and memory.

使用绑定参数的原因是让数据库一次解析sql，对后续的重复请求复用生成好的执行计划，这样做节省了CPU时间和内存。

youdao

Delegates have been in Barcelona all week to hash out a plan that would pave the way for 192 nations to sign a legally binding international climate deal next month.

VOA: standard.2009.11.06

Make no mistake: A comprehensive, long-term, binding plan that brings the budget into balance over a reasonable time frame is essential.

WSJ: Bill McNabb: Uncertainty Is the Enemy of Recovery

But perhaps the most important factor, the one absent at the national level, is a legally binding plan to reduce carbon emissions.

FORBES: How Will California Slash Greenhouse Gas Emissions 80% By 2050?

Labor groups have pushed retailers to sign the legally binding plan, a lengthier version of an agreement that was proposed about two years ago.

WSJ: Trade group slams safety pact for Bangladesh