| 单词 | nonclustered index | ||||||||||||||
| 释义 | nonclustered index
更多释义 收起释义 例句释义: 非聚集索引,非聚族索引,非簇索引 1. Note that this value does not include the leaf level of the nonclustered index. 请注意，此值不包括叶级非聚集索引。 technet.microsoft.com 2. When a nonclustered index is not disabled, the rebuild operation requires enough temporary disk space to store both the old and new index. 如果未禁用非聚集索引，则重新生成操作要求有足够的临时磁盘空间来存储旧索引和新索引。 msdn2.microsoft.com 3. 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（默认设置）。 technet.microsoft.com 4. This allows the storage engine to retrieve data rows from the underlying table before it has completed the scan of the nonclustered index. 这可以使存储引擎在完成非聚集索引的扫描之前从基础表中检索数据行。 msdn2.microsoft.com 5. A nonclustered index can be converted to a clustered index type by specifying CLUSTERED in the index definition. 通过在索引定义中指定CLUSTERED，可以将非聚集索引转换成聚集索引类型。 msdn2.microsoft.com 6. Specifies the error response to duplicate key values in a multiple-row insert operation on a unique clustered or unique nonclustered index. 指定对唯一聚集索引或唯一非聚集索引执行多行插入操作时出现重复键值的错误响应。 msdn2.microsoft.com 7. An administrator wants to determine the performance impact of adding a nonclustered index to a table. 管理员要确定向表中添加非聚集索引对性能的影响。 msdn2.microsoft.com 8. A nonclustered index can be defined on a table or view with a clustered index or on a heap. 既可以使用聚集索引来为表或视图定义非聚集索引，也可以根据堆来定义非聚集索引。 msdn2.microsoft.com 9. The bottom level of a clustered or nonclustered index. 聚集索引或非聚集索引的底层。 technet.microsoft.com 10. 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索引使用所有适用于非聚集索引的索引选项。 technet.microsoft.com 1. The following example creates a unique nonclustered index on the Name column of the Production. UnitMeasure table. 以下示例为Production.UnitMeasure表的Name列创建唯一的非聚集索引。 technet.microsoft.com 2. The leaf rows of a nonclustered index contain pointers to the data rows that contain each specific key value. 非聚集索引的叶级行包含指针，指向含有每个特定键值的数据行。 msdn2.microsoft.com 3. In this case, one table is a heap with no indexes, and the other table is a heap with a nonclustered index. 在此示例中，一个表为没有索引的堆，另一个表为具有非聚集索引的堆。 msdn2.microsoft.com 4. A unique clustered index must be created on a view before any nonclustered index is created. 必须先为视图创建唯一的聚集索引，才能为该视图创建非聚集索引。 msdn2.microsoft.com 5. Calculate the space used to store index information in the nonleaf levels of the nonclustered index. 计算用于存储非聚集索引的非叶级中的索引信息的空间。 technet.microsoft.com 6. When a nonclustered index is disabled, the index data rows are deleted, but the index definition remains in metadata. 禁用非聚集索引后，将删除索引数据行，但索引定义仍在元数据中。 msdn2.microsoft.com 7. Calculate the space used to store index information in the leaf level of the nonclustered index. 计算用于存储非聚集索引的叶级中的索引信息的空间。 technet.microsoft.com 8. Unless a clustered index is explicitly specified, a unique, nonclustered index is created by default to enforce the UNIQUE constraint. 除非显式指定了聚集索引，否则，默认情况下将创建唯一的非聚集索引以强制执行UNIQUE约束。 technet.microsoft.com 9. If the nonclustered index is over a clustered index, the data row locator is the clustering key. 如果非聚集索引在聚集索引之上，则数据行定位符是聚集键。 technet.microsoft.com 10. Each index row in the nonclustered index contains the nonclustered key value and a row locator . 该索引包含指向表数据存储位置的行定位符。 www.bing.com 1. The base table structure is not dependent on the structure of a nonclustered index. 基表结构依赖于非聚集索引的结构。 msdn2.microsoft.com 2. Disabling a nonclustered index or clustered index on a view physically deletes the index data. 对视图禁用非聚集索引或聚集索引会以物理方式删除索引数据。 technet.microsoft.com 3. This also applies to nonclustered index leaf rows that have included columns. 这也适用于具有包含性列的非聚集索引叶行。 technet.microsoft.com 4. If the nonclustered index is on the primary key, any active, referencing FOREIGN KEY constraints will automatically be disabled. 如果非聚集索引在主键上，将自动禁用引用FOREIGNKEY的任何活动约束。 msdn2.microsoft.com 5. If the nonclustered index is over a heap, the data row locator is the heap RID. 如果非聚集索引在堆上，则数据行定位符是堆RID。 technet.microsoft.com 6. By default, this index is clustered; however, you can specify a nonclustered index when you create the constraint. 默认情况下，此索引是聚集索引，但是在创建约束时，可以指定创建非聚集索引。 msdn2.microsoft.com 7. By default, a nonclustered index is created if clustered is not specified. 默认情况下，如果未指定聚集，将创建非聚集索引。 technet.microsoft.com 8. If CLUSTERED is not specified, a nonclustered index is created. 如果没有指定CLUSTERED，则创建非聚集索引。 msdn2.microsoft.com 9. Disabling a nonclustered index physically deletes the index data. 禁用非聚集索引将物理删除索引数据。 msdn2.microsoft.com 10. These additional columns are only stored at the leaf level of the nonclustered index. 这些额外的列只存储在叶级非聚集索引。 technet.microsoft.com 1. Clustered or nonclustered index on the column or columns defined in the constraint. 约束中定义的列的聚集索引或非聚集索引。 technet.microsoft.com 2. Specifies that a clustered or nonclustered index is created for the PRIMARY KEY or UNIQUE constraint. 指定为PRIMARYKEY或UNIQUE约束创建聚集或非聚集索引。 msdn2.microsoft.com 3. An offline index operation that creates a nonclustered index acquires a Shared (S) lock on the table. 创建非聚集索引的脱机索引操作将对表获取共享（S）锁。 technet.microsoft.com 4. If a nonclustered index is being rebuilt, a shared lock is held on the table in question for the duration of the operation. 如果重新生成了非聚集索引，则在该操作的持续时间内，相关表持有共享锁。 technet.microsoft.com 5. Clustered or nonclustered index on the ProductModelID column. ProductModelID列的聚集索引或非聚集索引。 technet.microsoft.com 6. The following example creates a nonclustered index on the VendorID column of the Purchasing. ProductVendor table. 以下示例为Purchasing.ProductVendor表的VendorID列创建非聚集索引。 technet.microsoft.com 7. In this case, the table in Node 1 is a heap with no indexes, and the table in Node 2 is a heap with a nonclustered index. 在此示例中，节点1中的表为没有索引的堆，节点2中的表为具有非聚集索引的堆。 msdn2.microsoft.com 8. The nonclustered index if the pages are nonclustered index pages. 非聚集索引，如果页是非聚集索引页。 msdn2.microsoft.com 9. In earlier versions of SQL Server, you could sometimes rebuild a nonclustered index to correct inconsistencies caused by hardware failures. 在早期版本的SQLServer中，您有时可以重新生成非聚集索引来更正由硬件故障导致的不一致。 technet.microsoft.com 10. Indicate that a clustered or a nonclustered index is created for the PRIMARY KEY or UNIQUE constraint. 指示为PRIMARYKEY或UNIQUE约束创建聚集索引还是非聚集索引。 msdn2.microsoft.com 1. You can rebuild a disabled nonclustered index online when the table does not have a disabled clustered index. 表中没有已禁用的聚集索引时，可以联机重新生成已禁用的非聚集索引。 msdn2.microsoft.com 2. In earlier versions of SQL Server, the nonclustered index and the base table in the other filegroup are checked. 在早期版本的SQLServer中，会检查其他文件组中的非聚集索引和基表。 technet.microsoft.com 3. Nonclustered index on an indexed view 索引视图的非聚集索引 technet.microsoft.com 4. Each nonclustered index created for a table or a view has a row in 为表或视图创建的每个非聚集索引在 msdn2.microsoft.com 5. You can use the following steps to estimate the amount of space that is required to store a nonclustered index 可使用下列步骤估计存储非聚集索引所需的空间大小 msdn2.microsoft.com |
||||||||||||||
| 随便看 |
|
英汉双解词典包含2704715条英汉词条，基本涵盖了全部常用单词的翻译及用法，是英语学习的有利工具。