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約束。
