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

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

youdao

A statistics profile is registered or stored in the table descriptor and system catalogs when the command parameter "SET profile" is added to the RUNSTATS command.

当将命令参数“SET PROFILE”添加到RUNSTATS命令时，将在表描述符和系统目录中注册或存储统计信息配置文件。

youdao

The parameter ALLOW WRITE ACCESS in a RUNSTATS command specifies that other users can read from and write to the table while statistics are calculated.

在 RUNSTATS 命令中的参数 ALLOW WRITE ACCESS 指定计算统计信息时，其他用户可以读取或写入该表。

youdao