如前所述,在使用RUNSTATS命令生成统计信息时,并不是总会收集分布统计信息。
As already mentioned, distribution statistics are not always collected when statistics are generated using the RUNSTATS command.
生成分布统计信息意味着给DB 2带来额外的、可观的开销,从而影响RUNSTATS命令的执行时间。
Generating distribution statistics means a significant, additional expense for DB2 and, therefore, influences the execution time of the RUNSTATS command.
此外,如果需要收集CARS表中所有列的分布统计信息(频率统计信息和分位数统计信息),那么可以执行以下命令。
If, in addition, distribution statistics (frequency and quantile statistics) should be collected for all columns of the table CARS, execute the following command.
应用推荐