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.
然而，如果每个不同的索引值都有许多重复的行，而所关联的表是高度群集的，那么通过索引添加的连接成本可能很低。
The index exploited for the inner table happens to be a clustered index.
利用内部表的索引恰好是一个聚集索引。
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 indexes that exist on a table, including the columns that they index, whether they are ascending or descending, and whether they are clustered.
存在于表上的索引，包括它们索引的列，哪些是升序或降序的，以及哪些是群集的。
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.
一般来说，如果内部索引是良好的集群且预测内部表被多次探测，则使用复合排序的嵌套循环联将受到优化器的青睐。
Your clustered index is the order the data is stored in the table, so you can only have one clustered index per table.
你的聚集索引顺序表中的数据存储，所以你每个表只能有一个聚集索引。
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)。
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列和列上的聚集的索引设置转换过程中。
The Oracle data block format is similar regardless of whether the data block contains table, index, or clustered data.
数据块的这部分包括了表和索引的数据。
The Oracle data block format is similar regardless of whether the data block contains table, index, or clustered data.
数据块的这部分包括了表和索引的数据。
应用推荐