For static SQL in a package (like SQL stored procedures), use of parameter markers while still allowing optimization by value can be accomplished through the REOPT ALWAYS bind or precompile options.

对于一个包中的静态SQL(比如s QL存储过程)，通过REOPT ALWAYS绑定或预编译选项，可以使用参数标记同时允许通过值进行优化。

youdao

New SET OPTIMIZATION ENVIRONMENT options are also introduced for influencing optimizer consideration of star join plans.

也引入了新的SET OPTIMIZATION ENVIRONMENT选项，用于影响优化器对星型连接计划的考虑。

youdao

Query Options File (QAQQINI) — the OPTIMIZATION_GOAL option can be specified with one of the following values to control the optimization goal for the entire system or a specific connection (job).

Query Options File (QAQ QINI)——可以通过将OPTIMIZATION _ GOAL选项指定为以下几个值之一，来控制整个系统或一个特定连接(任务)的优化目标。

youdao

The increase in revenue, will largely come from expanded customer options resulting from the greater scope and scale of the network as well as fleet optimization.

FORBES: United Continental Has Upside To $28 Despite Low-Price Threat