生成分布统计信息意味着给DB 2带来额外的、可观的开销,从而影响RUNSTATS命令的执行时间。
Generating distribution statistics means a significant, additional expense for DB2 and, therefore, influences the execution time of the RUNSTATS command.
如前所述,在使用RUNSTATS命令生成统计信息时,并不是总会收集分布统计信息。
As already mentioned, distribution statistics are not always collected when statistics are generated using 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.
应用推荐