Only one clustered index can exist per table.
对于每个表,只允许存在一个聚集索引。
A table can contain only one clustered index.
一个表只能包含一个聚集索引。
Keep clustered index keys as small as possible.
使聚集索引的键尽可能的小。
Views must have the same unique, clustered index.
视图必须具有相同的唯一聚集索引。
As you can see, the plan changes to clustered index scan.
就像你看到的,执行计划已经变为聚集索引扫描了。
Create a clustered index or recluster an existing index (new in 10.00)
创建聚族索引或者重新聚族已有索引(10.00中新增)。
For a clustered table, the row locator is the clustered index key.
对于聚集表,行定位器是聚集索引键。
Nonclustered index USES key into clustered index instead of address?
非聚集索引使用钥匙进入聚集索引而不是地址?
This select executes just fine with clustered index seek in the plan.
这条查询语句在聚集索引查找下很顺利的执行成功。
DATA already sorted creates the clustered index with the SORTED_DATA option.
“数据已经排序”用SORTED _ DATA选项来创建聚集索引。
Because you generally would much prefer to have the narrowest covering (probably non-clustered) index.
因为你通常可能更倾向于有窄覆盖(可能非集群)指数。
Because you generally would much prefer to have the narrowest covering (probably non-clustered) index.
因为你通常可能更倾向于有窄覆盖(可能非集群)指数。
应用推荐