It is normally not a good idea to have a 3-column clustering key.
它通常不是一个好主意有三栏集群的关键。
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列。
Multi DIMENSIONAL CLUSTERING (MDC) - organizing data in table (or range of a table) by multiple key values.
MULTI DIMENSIONAL CLUSTERING (MDC)——根据多个键值组织表(或一个表中的范围)中的数据。
应用推荐