为了允许自动生成统计信息配置文件,需要设置两个数据库配置参数。
To enable automatic statistics profile generation, set two database configuration parameters on.
DB2在生成统计信息时,不但能提供基本统计信息,还允许创建所谓的分布统计信息。
When generating statistics, DB2 offers the possibility to create so-called distribution statistics in addition to the basic statistics.
如前所述,在使用RUNSTATS命令生成统计信息时,并不是总会收集分布统计信息。
As already mentioned, distribution statistics are not always collected when statistics are generated using the RUNSTATS command.
应用推荐