尽可能避免表上有任何索引，尤其是不要有群集索引。
Avoid having any indexes on the table, if possible, but particularly not a clustering index.
在非群集索引下，数据在物理上随机存放在数据页上。
In be not teeming index to fall, data is deposited randomly on physics go up in data page.
分配空余空间的主要目的是使数据行的物理顺序与群集索引一致，以减少频繁重组数据的需要。
The main purpose of allocating free space is to keep the data rows in the same physical sequence as the clustering index, thus reducing the need to frequently reorganize the data.
不过，如果允许太多自由空间的存在，则可能导致查询时需要读取额外的页，这反而大大违反了使用群集索引的本意。
Allowing too much free space, however, could cause extra pages to be read for queries and largely defeat the purpose of using a clustering index.
在进行重组之后，索引NAMES_FULL_NAME将具有一个极低的群集因子(接近于0)，因为现在的行是以随机次序存储的。
After the reorganization, the index NAMES_FULL_NAME will have a very low cluster factor (close to 0), because the rows are now stored in random order.
存在于表上的索引，包括它们索引的列，哪些是升序或降序的，以及哪些是群集的。
The indexes that exist on a table, including the columns that they index, whether they are ascending or descending, and whether they are clustered.
然而，如果每个不同的索引值都有许多重复的行，而所关联的表是高度群集的，那么通过索引添加的连接成本可能很低。
However, if there are many duplicate rows per distinct index value, and the associated table is highly clustered, the added costs of joining through the index can be slight.
如果您期望一个索引具有较高的群集因子，就只要重组该索引上的表。
If you expect an index to have a high cluster factor, just reorganize the table on that index.
对于索引控制的分区方法，分区的表、分区索引和群集这几个概念之间有点纠缠不清。
Under index-controlled partitioning, the concepts of partitioned table, partitioning index and clustering were all intertwined.
一个索引的群集程度；即，表中行的物理顺序与索引的符合程度。
The degree of clustering of an index; that is, the extent to which the physical sequence of rows in a table follows an index.
常见的替代项包括索引列或其他唯一键列的群集。
Common alternatives include clustering index columns or other unique key columns.
常见的替代项包括索引列或其他唯一键列的群集。
Common alternatives include clustering index columns or other unique key columns.
应用推荐