In explicit UPDATE STATISTICS operations in MEDIUM mode, a new SAMPLING SIZE option in the Resolution clause can specify the minimum number of rows to sample for column distributions.
在MEDIUM模式的显式的UPDATE STATISTICS操作中,resolution子句中新的SAMPLING SIZE选项可以指定列分布进行抽样的最少行数。
In MEDIUM or HIGH mode, a histogram of the column data is created.
在MEDIUM或HIGH模式下,将创建列数据的柱状图。
The following listing shows the distribution of the above data when the UPDATE STATISTICS is run in medium mode with a resolution of 10.
在 medium 模式下采用分辨率 10 运行 UPDATE STATISTICS 时,以上数据的分布如下面的清单所示。
应用推荐