You can include columns that contain row - overflow data as key or nonkey columns of a nonclustered index 可以包括包含行溢出数据的列,作为非聚集索引的键列或非键列。
That is , all columns referenced in the query are included in the index as either key or nonkey columns 也就是说,查询中引用的所有列都作为键列或非键列包含在索引中。
The index must be created or rebuilt offline online off if any one of the specified nonkey columns are 之外,允许所有数据类型。如果指定的任一非键列属于varchar ( max )
Reorganizing a nonclustered index compacts all lob columns that are nonkey included columns in the index 重新组织非聚集索引将压缩索引中属于非键包含性列的所有lob列。
Data types can be nonkey included columns as long as the computed column data type is allowed as a nonkey index column 数据类型派生的计算列就可以作为非键(包含性)列。
Column names cannot be repeated in the include list and cannot be used simultaneously as both key and nonkey columns Include列表中列名不能重复,且列不能同时用作键列和非键列。
Gets a dictionary containing the revised values of the non - key field name value pairs in the row to update 获取一个字典,该字典包含待更新行中的非键字段名称/值对的修改后的值。
Reorganizing a nonclustered index will compact all lob columns that are nonkey included columns in the index 重新组织非聚集索引将压缩该索引中属于非键(包含性)列的所有lob列。
The database engine does not consider nonkey columns when calculating the number of index key columns or index key size 数据库引擎计算索引键列数或索引键大小时,不考虑非键列。
The total size of all nonkey columns is limited only by the size of the columns specified in the include clause ; for example , 所有非键列的总大小只受include子句中所指定列的大小限制;例如,