What happens when the order of the index column is random?
当索引列的顺序是随机的时候，将会发生什么呢？
But what happens when the order of the index column is random?
但是如果索引列的顺序是随机的，将会发生什么呢？
Create your indexes in the order in which you want those index column predicates applied.
按照您想应用索引列谓词的顺序创建您的索引。
Therefore a randomized index column can relieve contention problems for sets of similar or sequential values, but it's no help with identical values.
因此，随机化的列可以减轻一组相似值或序列值的争用问题，但对于相同的值没有帮助。
The operator class also specifies the support procedures to be used by the index method when the operator class is selected for an index column.
操作符表还声明索引方法在为一个索引字段选定该操作符表的时候要使用的支持过程。
REBUILD will automatically rebuild all index-column statistics, whereas REORGANIZE won't update statistics at all.
重建将自动重建所有索引列统计信息，而重新组织根本不会更新统计信息。
REBUILD will automatically rebuild all index-column statistics, whereas REORGANIZE won't update statistics at all.
重建将自动重建所有索引列统计信息，而重新组织根本不会更新统计信息。
应用推荐