What if you know your OLTP searches should use the same execution plan for different binding values?
要是你知道你的OLTP搜索对不同绑定值应该使用相同执行计划又该怎么办呢?
The binding you choose depends on how you plan to access the component.
所选择的绑定取决于计划如何访问组件。
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时间和内存。
Oracle 9i and later can peek at the values of binding parameters on the first invocation and generate an execution plan.
Oracle9i及以后版本在第一次调用绑定参数并生成执行计划时能探出参数值。
California now has binding targets to cut CO2 emissions, and other states plan to follow.
加州确立了CO2减排的死目标,其它州也纷纷准备效仿。
Law is the most standard norm which has the compulsion binding force to ensure the standard function of the plan can display.
如何保证规划的规范作用得以发挥,法律是最有强制约束力的制度和规范。
The other type of early plan, early action (EA) is not binding—and you can apply EA to multiple colleges.
但是也有另一种提前录取方式,就是EA,这种方式不是绑定的,你可以选择多所学校。
The other type of early plan, early action (EA) is not binding—and you can apply EA to multiple colleges.
但是也有另一种提前录取方式,就是EA,这种方式不是绑定的,你可以选择多所学校。
应用推荐