利用内部表的索引恰好是一个聚集索引。
The index exploited for the inner table happens to be a clustered index.
视图必须具有相同的唯一聚集索引。
一个表只能包含一个聚集索引。
使聚集索引的键尽可能的小。
对于聚集表，行定位器是聚集索引键。
For a clustered table, the row locator is the clustered index key.
对于每个表，只允许存在一个聚集索引。
聚集索引将会更快。
非聚集索引使用钥匙进入聚集索引而不是地址？
Nonclustered index USES key into clustered index instead of address?
在计算列上建非聚集索引是有物理保存的吗?。
Computed column ' in table ' cannot be persisted because the column is non-deterministic.
就像你看到的，执行计划已经变为聚集索引扫描了。
这条查询语句在聚集索引查找下很顺利的执行成功。
This select executes just fine with clustered index seek in the plan.
聚集索引是最快的SELECT，但它不一定是正确的选择。
A clustered index would be the fastest for that SELECT, but it may not necessarily be correct choice.
对于聚集索引：如果要移动聚集索引，则可以使用在线处理。
For clustered indexes: if you are moving a clustered index you can use online processing.
扫描聚集索引，可以扫描全部内容，也可以只扫描一个范围。
Number of unrestricted full scans. These can either be base table or full index scans.
你的聚集索引顺序表中的数据存储，所以你每个表只能有一个聚集索引。
Your clustered index is the order the data is stored in the table, so you can only have one clustered index per table.
“数据已经排序”用SORTED _ DATA选项来创建聚集索引。
DATA already sorted creates the clustered index with the SORTED_DATA option.
聚集索引确定的顺序记录物理存储(这就是为什么你每个表只能有一个)。
A clustered index determines the order in which records are physically stored (which is why you can only have one per table).
相反，离线重新生成索引将会强制扫描聚集索引(或堆)，因此会删除不一致。
Rebuilding the index offline, by contrast, will force a scan of the clustered index (or heap) and so remove the inconsistency.
并且聚集索引中数据页就是页级别索引页，综合上述两点，聚集索引占据空间更小。
The leaf-level pages store the index keys and page pointers, plus a pointer to the row offset table on the data page.
聚集索引通常可加快UPDATE和DELETE操作的速度，因为这些操作需要读取大量的数据。
UPDATE and DELETE operations are often accelerated by clustered indexes because these operations require large amounts of data to be read.
实验证明，该方法能够自适应地划分合理的日志区空间，有效提高查询性能，减少各种非聚集索引的更新代价。
The experimental results prove that it can make a proper log region allocation, efficiently improve search performance, and reduce non-clustered index update cost.
重新组织索引时，除了重新组织一个或多个索引外，默认情况下还将压缩聚集索引或基础表中包含的大型对象数据类型(lob)。
Besides reorganizing one or more indexes, large object data types (LOBs) that are contained in the clustered index or underlying table are compacted by default when an index is reorganized.
在DB 2中建立数据聚集属性的方法是根据一个索引对表进行重组。
The way to establish a certain data clustering property in DB2 is to reorganize the table according to an index.
添加一个有索引的聚集列的步骤非常类似于清单8中展示的步骤。
The steps to add an indexed clustering column are very similar to the ones shown in Listing 8.
Swotti是个语义搜索引擎，聚集了关于产品的意见，有助于你做购买决定。
Swotti is a semantic search engine that aggregates opinions about products to help you make purchasing decisions.
(聚集或非聚集)索引类型未指定。
你可能会考虑使用一个简单的另一个单列身份集群键，并创建一个索引视图聚集在3列。
You may consider an alternative of using a simple single-column identity clustering key, and creating an indexed view clustered around the 3 columns.
索引视图与聚集表具有相同的存储结构。
Indexed views have the same storage structure as clustered tables.
如果源表不包含主键或聚簇的索引，该工具可以自动添加rowid列和列上的聚集的索引设置转换过程中。
If the source table doesn't include a primary key or clustered index, the tool can automatically add a ROWID column and set the clustered index on the column during the conversion.
如果源表不包含主键或聚簇的索引，该工具可以自动添加rowid列和列上的聚集的索引设置转换过程中。
If the source table doesn't include a primary key or clustered index, the tool can automatically add a ROWID column and set the clustered index on the column during the conversion.
应用推荐