非聚集索引 的英文怎麼說
中文拼音 [fēijùjísuǒyǐn]
非聚集索引
英文
nonclustered index- 非 : Ⅰ名詞1 (錯誤) mistake; wrong; errors 2 (指非洲) short for africa 3 (姓氏) a surname Ⅱ動詞1 ...
- 聚 : 動詞(聚集; 聚積) assemble; gather; get together
- 集 : gatherassemblecollect
- 索 : Ⅰ名詞1 (大繩子; 大鏈子) a large rope 2 (姓氏) a surname Ⅱ動詞1 (搜尋; 尋找) search 2 (要; ...
- 引 : Ⅰ動詞1 (牽引; 拉) draw; stretch 2 (引導) lead; guide 3 (離開) leave 4 (伸著) stretch 5 (...
- 聚集 : 1 (集合; 湊在一起) gather; assemble; collect 2 [工業] accumulation;congestion; concrescence; re...
- 索引 : index; indexing; key; repertory; subscript; concordance
-
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索引使用所有適用於非聚集索引的索引選項。The pointer from an index row in a nonclustered index to a data row is called a row locator
從非聚集索引中的索引行指向數據行的指針稱為行定位器。Each index row in the nonclustered index contains the nonclustered key value and a row locator
非聚集索引中的每個索引行都包含非聚集鍵值和行定位符。Explains how index rows are stored in a nonclustered index and how they are accessed and maintained
說明如何將索引行存儲在非聚集索引中,以及如何對其進行訪問和維護。Nonclustered index structures
非聚集索引結構Nonclustered indexes have a b - tree index structure similar to the one in clustered indexes
非聚集索引與聚集索引有一個相似的b樹索引結構。You can include columns that contain row - overflow data as key or nonkey columns of a nonclustered index
可以包括包含行溢出數據的列,作為非聚集索引的鍵列或非鍵列。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
非聚集索引包含非聚集索引鍵值,並且每個鍵值項都有指向包含該鍵值的數據行的指針。Including nonkey columns in nonclustered indexes
在非聚集索引中包含非鍵列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強制執行表掃描。An administrator wants to determine the performance impact of adding a nonclustered index to a table
管理員要確定向表中添加非聚集索引對性能的影響。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索引執行物理一致性檢查。Nonclustered index design guidelines
非聚集索引設計指南Specifies the nonkey columns to be added to the leaf level of the nonclustered index
指定要添加到非聚集索引的葉級別的非鍵列。The base table structure is not dependent on the structure of a nonclustered index
基表結構依賴于非聚集索引的結構。Specifies that the named, preexisting clustered, nonclustered, or xml index is dropped and rebuilt
指定應刪除並重新生成已命名的先前存在的聚集、非聚集索引或xml索引。All clustered and nonclustered indexes on tables
表中的所有聚集索引和非聚集索引Primary key constraint with a nonclustered index
具有非聚集索引的primary key約束。Unique nonclustered indexes cannot be created online
不能在線創建唯一的非聚集索引。分享友人