nonclustered

非聚集的：指不是以群集形式存在的

常用释义

adj. 非聚集的：指不是以群集形式存在的，通常用于描述数据存储或分布。

扩展信息

非聚集索引

非聚集索引(NONCLUSTERED)：表中各行的物理顺序与键值的逻辑（索引）顺序不匹配，表中可以有249个非聚集索引 3.创建 …

非丛集

2.若建立索引时未指令为丛集或非丛集时，预设为建立非丛集(NONClustered)索引。3.若此资料表具有主索引键(Primary key)， …

非聚簇

类型: 聚簇(Clustered)索引、非聚簇(Nonclustered)索引和唯一索引。聚簇索引：表中数据与索引存储在相邻物理空间，且表中 …

非簇索引

• 非簇索引(nonclustered)—非簇索引与簇索引按完全不同的结构对数据排序。非簇索引有一个索引键值与行中的值相关联，这 …

非聚集索引关键字

...设为主键primary key后再添加索引要包括非聚集索引关键字（nonclustered）或聚集索引（clustered）这样： PK_t_employe…

非簇表

簇表（clustered）内的行需要存储与非簇表（nonclustered）行相同的信息。除此之外，簇表内各行还需要存储其所属的簇键（…

创建非聚集索引

例句

Note that this value does not include the leaf level of the nonclustered index.

请注意，此值不包括叶级非聚集索引。

If CLUSTERED is specified for a UNIQUE constraint and a PRIMARY KEY constraint is also specified, the PRIMARY KEY uses NONCLUSTERED.

如果为UNIQUE约束指定了CLUSTERED，并且指定了PRIMARYKEY约束，则PRIMARYKEY使用NONCLUSTERED。

When a nonclustered index is not disabled, the rebuild operation requires enough temporary disk space to store both the old and new index.

如果未禁用非聚集索引，则重新生成操作要求有足够的临时磁盘空间来存储旧索引和新索引。

When you create a clustered or nonclustered index, the IGNORE_DUP_KEY option must be set to OFF (the default setting).

创建聚集索引或非聚集索引时，IGNORE_DUP_KEY选项必须设置为OFF（默认设置）。

This allows the storage engine to retrieve data rows from the underlying table before it has completed the scan of the nonclustered index.

这可以使存储引擎在完成非聚集索引的扫描之前从基础表中检索数据行。

A nonclustered index can be converted to a clustered index type by specifying CLUSTERED in the index definition.

通过在索引定义中指定CLUSTERED，可以将非聚集索引转换成聚集索引类型。

Nonclustered indexes do not have to be scanned to validate the base table.

不必扫描非聚集索引就可验证基表。

Redesign nonclustered indexes with a large index key size so that only columns used for searching and lookups are key columns.

重新设计索引键大小较大的非聚集索引，以便只有用于搜索和查找的列为键列。

ON option so the DROP INDEX transaction does not block queries and modifications to the underlying data and associated nonclustered indexes.

ON选项，这样DROPINDEX事务就不会阻塞对基础数据和相关的非聚集索引的查询和修改。

Specifies the error response to duplicate key values in a multiple-row insert operation on a unique clustered or unique nonclustered index.

指定对唯一聚集索引或唯一非聚集索引执行多行插入操作时出现重复键值的错误响应。

An administrator wants to determine the performance impact of adding a nonclustered index to a table.

管理员要确定向表中添加非聚集索引对性能的影响。

Therefore, even if the nonclustered indexes were previously aligned with the clustered index, they may no longer be aligned with the heap.

因此，即使非聚集索引以前与聚集索引对，它们也可能不再与堆对。

A nonclustered index can be defined on a table or view with a clustered index or on a heap.

既可以使用聚集索引来为表或视图定义非聚集索引，也可以根据堆来定义非聚集索引。

The bottom level of a clustered or nonclustered index.

聚集索引或非聚集索引的底层。

These physical performance structures include clustered indexes, nonclustered indexes, indexed views, and partitioning.

这些物理性能结构包括聚集索引、非聚集索引、索引视图和分区。

Existing nonclustered indexes and XML indexes associated with the table are automatically disabled and cannot be accessed.

与表相关的现有非聚集索引和XML索引都自动禁用，因此无法访问。

Create nonclustered indexes on all columns that are frequently used in predicates and join conditions in queries.

为经常用于查询中的谓词和联接条件的所有列创建非聚集索引。

The process of determining disk space requirements for unique indexes is the same as that of clustered and nonclustered indexes.

确定唯一索引的磁盘空间需求的过程与聚集索引和非聚集索引相同。

Rebuilding a clustered index does not rebuild associated nonclustered indexes unless the keyword ALL is specified.

重新生成聚集索引并不重新生成关联的非聚集索引，除非指定了关键字ALL。

All indexing options that apply to a nonclustered index, except IGNORE_DUP_KEY and ONLINE, are permitted on secondary XML indexes.

除了IGNORE_DUP_KEY和ONLINE之外，允许对辅助XML索引使用所有适用于非聚集索引的索引选项。

Physical design structures include clustered indexes, nonclustered indexes, indexed views, and partitioning.

物理设计结构包括聚集索引、非聚集索引、索引视图和分区。

Added unique nonclustered indexes to the list of indexes that cannot be created online.

向无法在线创建的索引列表中添加了唯一非聚集索引。

The following example creates a unique nonclustered index on the Name column of the Production. UnitMeasure table.

以下示例为Production.UnitMeasure表的Name列创建唯一的非聚集索引。

Rebuilding the clustered index on a view does not automatically enable nonclustered indexes on the view.

重新生成视图的聚集索引不会自动启用视图的非聚集索引。

CLUSTERED and NONCLUSTERED cannot be specified for CLR table-valued functions.

不能为CLR表值函数指定CLUSTERED和NONCLUSTERED。

The leaf rows of a nonclustered index contain pointers to the data rows that contain each specific key value.

非聚集索引的叶级行包含指针，指向含有每个特定键值的数据行。

Columns that are not part of the index key can be included in nonclustered indexes.

可以将不属于索引键的列包含在非聚集索引中。

That is, all page locks are disallowed on the nonclustered indexes.

也就是说，对非聚集索引禁用所有页锁。

Generally, nonclustered indexes are created to improve the performance of frequently used queries not covered by the clustered index.

通常，创建非聚集索引是为了提高聚集索引未包含的常用查询的性能。

Conversion from clustered to nonclustered is not supported regardless of the ONLINE setting.

不管将ONLINE设置成什么，都不支持从聚集索引到非聚集索引的转换。