nonclustered indexes 中文意思是什麼
-
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索引使用所有適用於非聚集索引的索引選項。 -
Nonclustered indexes have a b - tree index structure similar to the one in clustered indexes
非聚集索引與聚集索引有一個相似的b樹索引結構。 -
Including nonkey columns in nonclustered indexes
在非聚集索引中包含非鍵列 -
When all is specified, relational indexes, both clustered and nonclustered, and xml indexes on the table are reorganized
如果指定all ，將重新組織表中的關系索引（包括聚集索引和非聚集索引）和xml索引。 -
Dbcc checktable performs consistency checks on a single table or indexed view and all its nonclustered and xml indexes, unless the noindex option is specified. to perform dbcc checktable on every table in the database, use
除非指定noindex選項，否則， dbcc checktable將對單個表或索引視圖及其所有非聚集索引以及xml索引執行物理一致性檢查。 -
All clustered and nonclustered indexes on tables
表中的所有聚集索引和非聚集索引 -
Unique nonclustered indexes cannot be created online
不能在線創建唯一的非聚集索引。 -
To the heap and any associated nonclustered indexes
應用於堆和任何關聯的非聚集索引。 -
Clustered and nonclustered indexes only
僅保留聚集索引和非聚集索引。 -
A heap with lob data and no nonclustered indexes, and
，具有lob數據但沒有非聚集索引的堆； -
Performs both minor, nontime - consuming repair actions such as repairing extra keys in nonclustered indexes and time - consuming repairs such as rebuilding indexes
既執行次要且不耗時的修復操作（如修復非聚集索引中的額外關鍵字） ，也執行耗時的修復操作（如重建索引） 。 -
When all is specified, all indexes associated with the specified table or view are reorganized and all lob columns associated with the clustered index, underlying table, or nonclustered index with included columns are compacted
如果指定all ，將重新組織與指定的表或視圖相關聯的所有索引，並壓縮與聚集索引、基礎表或帶有包含性列的非聚集索引相關聯的所有lob列。 -
When all is specified, all indexes that are associated with the specified table or view are reorganized, and all lob columns that are associated with the clustered index, underlying table, or nonclustered index with included columns are compacted
指定all時，將重新組織與指定表或視圖相關聯的所有索引，並且壓縮與聚集索引、基礎表或具有已包括列的非聚集索引相關聯的所有lob列。 -
On is not valid for indexed views, nonclustered indexes or indexes on local temp tables
On對于索引視圖、非聚集索引或本地臨時表的索引無效。 -
When you build query plans for select statements, the query optimizer avoids nonclustered indexes and indexed views that reside in offline filegroups
在為select語句生成查詢計劃時，查詢優化器會避免駐留在脫機文件組中的非聚集索引和索引視圖。 -
Generates corresponding nonclustered indexes
生成相應的非聚集索引。
分享友人