nonclustered index 中文意思是什麼

nonclustered index 解釋
非聚集索引
  • index : n （pl es dices ）1 索引。2 指標，標準，標志。3 示[食]指 （＝index finger）。4 指數。5 【印刷】指...
  1. 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索引使用所有適用於非聚集索引的索引選項。
  2. The pointer from an index row in a nonclustered index to a data row is called a row locator

    從非聚集索引中的索引行指向數據行的指針稱為行定位器。
  3. Each index row in the nonclustered index contains the nonclustered key value and a row locator

    非聚集索引中的每個索引行都包含非聚集鍵值和行定位符。
  4. Explains how index rows are stored in a nonclustered index and how they are accessed and maintained

    說明如何將索引行存儲在非聚集索引中，以及如何對其進行訪問和維護。
  5. Nonclustered index structures

    非聚集索引結構
  6. You can include columns that contain row - overflow data as key or nonkey columns of a nonclustered index

    可以包括包含行溢出數據的列，作為非聚集索引的鍵列或非鍵列。
  7. A nonclustered index contains the nonclustered index key values and each key value entry has a pointer to the data row that contains the key value

    非聚集索引包含非聚集索引鍵值，並且每個鍵值項都有指向包含該鍵值的數據行的指針。
  8. The first example shows how to force the optimizer to use a nonclustered index to retrieve rows from a table, and the second example forces a table scan by using an index of 0

    優化器提示的兩種方式。第一個示例說明如何強制優化器使用非聚集索引檢索表中的行，第二個示例使用索引0強制執行表掃描。
  9. An administrator wants to determine the performance impact of adding a nonclustered index to a table

    管理員要確定向表中添加非聚集索引對性能的影響。
  10. Nonclustered index design guidelines

    非聚集索引設計指南
  11. Specifies the nonkey columns to be added to the leaf level of the nonclustered index

    指定要添加到非聚集索引的葉級別的非鍵列。
  12. The base table structure is not dependent on the structure of a nonclustered index

    基表結構依賴于非聚集索引的結構。
  13. The bottom level of a clustered or nonclustered index. in a clustered index, the leaf level contains the actual data pages of the table

    表中每一行代表由該表建模的對象出現的一個位置，並用來存儲該對象所有屬性的值。
  14. The following example disables a nonclustered index on the

    下面的示例禁用了對
  15. Primary key constraint with a nonclustered index

    具有非聚集索引的primary key約束。
  16. The nonclustered index can be unique or nonunique

    非聚集索引可以唯一，也可以不唯一。
  17. The following example creates a nonclustered index on the

    創建簡單非聚集索引以下示例為
  18. Primary key or unique constraint with a nonclustered index

    非聚集索引的primary key或unique約束。
  19. 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列。
  20. 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列。
分享友人
分享到 Line

分享到臉書