大家在查： number one political foe 阴阳怪气史蒂文·巴罗 bidet run riot 威廉·哈维量级带来了 bludger

非聚集

网络nonaggregated; Nonclustered; IsClustered

非聚集

非聚集

非聚集

nonaggregated

软件开发常用名词中英文对照 - Leo Liu - 博客园 ... node 节点 nonaggregated 非聚集 non-blank 非空白 ...

Nonclustered

...解释了索引的组织结构、聚集（Clustered）和非聚集（Nonclustered）索引的差异、数据分割（Partition）、SQL Server 创 …

IsClustered

SQL... ... Engine Edition 实例引擎版本。 IsClustered 0 = 非聚集。 IsIntegratedSecurityOnly 0 = 非集成安全模式。 ...

1

Therefore , even the non clustered indexes previously aligned with the clustered index , they may no longer be aligned with it .

所以，即使非聚集索引以前与聚集索引对齐，现在可能也不再与其对齐。

2

The pointer from an index row in a non clustered index to a data row is called a row locator .

从非聚集索引中的索引行指向数据行的指针称为行定位器。

3

Note that this value does not include the leaf level of the nonclustered index .

请注意，此值不包括叶级非聚集索引。

4

If you chose to generate indexes in the wizard, a non-clustered index is generated for each of these relationship columns.

如果您选择在向导中生成索引，则会为上述每个关系列生成一个非聚集索引。

6

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 （默认设置）。

8

A nonclustered index can be converted to a clustered index type by specifying CLUSTERED in the index definition .

通过在索引定义中指定 CLUSTERED ，可以将非聚集索引转换成聚集索引类型。

9

Nonclustered indexes do not have to be scanned to validate the base table .

不必扫描非聚集索引就可验证基表。

10

Redesign nonclustered indexes with a large index key size so that only columns used for searching and lookups are key columns .

重新设计索引键大小较大的非聚集索引，以便只有用于搜索和查找的列为键列。

15

Therefore , even if the nonclustered indexes were previously aligned with the clustered index , they may no longer be aligned with the heap .

因此，即使非聚集索引以前与聚集索引对，它们也可能不再与堆对。

16

The GROUP BY clause must contain all nonaggregated columns in the select list, and must not contain other columns not in the select list .

GROUPBY 子句必须包含选择列表中的所有非聚集列，而且不能包含选择列表中没有的其他列。

18

When a secondary index is to be created or dropped , the table will be locked in shared mode.

当非聚集索引被创建或删除，此表被加上共享锁。

19

The bottom level of a clustered or nonclustered index .

聚集索引或非聚集索引的底层。

23

24

Rebuilding a clustered index does not rebuild associated nonclustered indexes unless the keyword ALL is specified .

重新生成聚集索引并不重新生成关联的非聚集索引，除非指定了关键字 ALL 。

26

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 索引使用所有适用于非聚集索引的索引选项。

29

The following example creates a unique nonclustered index on the Name column of the Production. UnitMeasure table .

以下示例为 Production.UnitMeasure 表的 Name 列创建唯一的非聚集索引。

30

Rebuilding the clustered index on a view does not automatically enable nonclustered indexes on the view .

重新生成视图的聚集索引不会自动启用视图的非聚集索引。

热词推荐

大家在看