The clustered index will be faster.
聚集索引将会更快。
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.
对于聚集表,行定位器是聚集索引键。
The index exploited for the inner table happens to be a clustered index.
利用内部表的索引恰好是一个聚集索引。
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选项来创建聚集索引。
For clustered indexes: if you are moving a clustered index you can use online processing.
对于聚集索引:如果要移动聚集索引,则可以使用在线处理。
A clustered index would be the fastest for that SELECT, but it may not necessarily be correct choice.
聚集索引是最快的SELECT,但它不一定是正确的选择。
Your clustered index is the order the data is stored in the table, so you can only have one clustered index per table.
你的聚集索引顺序表中的数据存储,所以你每个表只能有一个聚集索引。
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 replay position advancement is necessary because the slow alter, alter fragment, and clustered index creation operations change the table partition Numbers.
重放位置的推进是必需的,因为slowalter、alterfragment和集群索引创建操作会改变表分区号。
The experimental results prove that it can make a proper log region allocation, efficiently improve search performance, and reduce non-clustered index update cost.
实验证明,该方法能够自适应地划分合理的日志区空间,有效提高查询性能,减少各种非聚集索引的更新代价。
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列和列上的聚集的索引设置转换过程中。
For the slow alter, alter fragment, or clustered index creation operations, the alter operation replay position is moved to the current log position before performing the operation.
对于slowalter、alter fragment或集群索引创建操作,在执行alter操作之前,alter操作的重放位置被移动到当前的日志位置。
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.
重新组织索引时,除了重新组织一个或多个索引外,默认情况下还将压缩聚集索引或基础表中包含的大型对象数据类型(lob)。
However, if there are many duplicate rows per distinct index value, and the associated table is highly clustered, the added costs of joining through the index can be slight.
然而,如果每个不同的索引值都有许多重复的行,而所关联的表是高度群集的,那么通过索引添加的连接成本可能很低。
In general, a nested loop join with sort composite is favored by the optimizer if the inner index is well-clustered and the inner table is expected to be probed many times.
一般来说,如果内部索引是良好的集群且预测内部表被多次探测,则使用复合排序的嵌套循环联将受到优化器的青睐。
The indexes that exist on a table, including the columns that they index, whether they are ascending or descending, and whether they are clustered.
存在于表上的索引,包括它们索引的列,哪些是升序或降序的,以及哪些是群集的。
Index type (CLUSTERED or NONCLUSTERED) not specified.
(聚集或非聚集)索引类型未指定。
This paper proposed a Clustered Multi Resolution String index structure to solve the problem of sequence similarity query.
本文提出了一种聚类的多解析度字符串索引结构,用于解决生物序列的相似性查询问题。
The answer to the question as stated in your subject line in general is no. Because you generally would much prefer to have the narrowest covering (probably non-clustered) index.
这个问题的答案所你的主题一般是否定的。因为你通常可能更倾向于有窄覆盖(可能非集群)指数。
Modify a primary key if you want to change the column order, index name, clustered option, or fill factor.
如果要更改列顺序、索引名称、聚集选项或填充因子,则要修改主键。
The Oracle data block format is similar regardless of whether the data block contains table, index, or clustered data.
数据块的这部分包括了表和索引的数据。
应用推荐