Once you understand your options, you can influence the optimizer to select the best query execution plan, either by adjusting the OPTCOMPIND parameter or by adding query directives or indexes.

一旦理解了自己的选择，就可以通过调整OPTCOMPIND参数，或者通过添加查询指示或索引，来影响优化器，从而选择最佳的查询执行计划。

youdao

In addition, it discusses the role of the optimizer, including the OPTCOMPIND parameter, query directives, and internal statistics.

此外，还将讨论优化器的角色，其中包括OPTCOMPIND参数、查询命令和内部统计数据。

youdao

The behavior of the optimizer is influenced by three key factors: the value of OPTCOMPIND parameter in the Informix configuration file, query directives, and the accuracy of internal statistics.

优化器的行为受三个关键因素的影响：Informix配置文件中OPTCOMPIND参数的值、查询命令和内部统计数据的准确性。

youdao