Quantile statistics provide the information whether the values of a column are clustered or not.
分位数统计信息提供关于一个列中的值是否聚合的信息。
The column has many duplicates (frequency statistics), or the values of the column are not evenly distributed, which means they are clustered in certain areas (quantile statistics)
该列有很多重复的值(频率统计信息),或者该列的值分布不均匀,即它们在某些局部是聚合的(分位数统计信息)。
You may consider an alternative of using a simple single-column identity clustering key, and creating an indexed view clustered around the 3 columns.
你可能会考虑使用一个简单的另一个单列身份集群键,并创建一个索引视图聚集在3列。
Modify a primary key if you want to change the column order, index name, clustered option, or fill factor.
如果要更改列顺序、索引名称、聚集选项或填充因子,则要修改主键。
If the source table doesn't include a primary key or clustered index, the tool can automatically add a ROWID column and set the clustered index on the column during the conversion.
如果源表不包含主键或聚簇的索引,该工具可以自动添加rowid列和列上的聚集的索引设置转换过程中。
If the source table doesn't include a primary key or clustered index, the tool can automatically add a ROWID column and set the clustered index on the column during the conversion.
如果源表不包含主键或聚簇的索引,该工具可以自动添加rowid列和列上的聚集的索引设置转换过程中。
应用推荐