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设置成什么，都不支持从聚集索引到非聚集索引的转换。
Online processing allows concurrent user access to the underlying data and to nonclustered indexes during the index operation.
在线处理使并发用户可以在索引操作期间访问基础数据和非聚集索引。
Unique nonclustered indexes cannot be created online.
不能在线创建唯一的非聚集索引。
In this case, one table is a heap with no indexes, and the other table is a heap with a nonclustered index.
在此示例中，一个表为没有索引的堆，另一个表为具有非聚集索引的堆。
A unique clustered index must be created on a view before any nonclustered index is created.
必须先为视图创建唯一的聚集索引，才能为该视图创建非聚集索引。
Calculate the space used to store index information in the nonleaf levels of the nonclustered index.
计算用于存储非聚集索引的非叶级中的索引信息的空间。
Nonclustered indexes defined with LOB data type columns must be created or rebuilt offline.
使用LOB数据类型列定义的非聚集索引必须脱机创建或重新生成。
When a nonclustered index is disabled, the index data rows are deleted, but the index definition remains in metadata.
禁用非聚集索引后，将删除索引数据行，但索引定义仍在元数据中。
Calculate the space used to store index information in the leaf level of the nonclustered index.
计算用于存储非聚集索引的叶级中的索引信息的空间。
Specifies that nonclustered indexes for user tables should not be checked.
指定不检查用户表的非聚集索引。
Unless a clustered index is explicitly specified, a unique, nonclustered index is created by default to enforce the UNIQUE constraint.
除非显式指定了聚集索引，否则，默认情况下将创建唯一的非聚集索引以强制执行UNIQUE约束。
