For a clustered table, the row locator is the clustered index key.
对于聚集表,行定位器是聚集索引键。
The results are shown for the clustered case only because the unclustered table yields the same numbers as before.
这里只显示聚集情况下的结果,因为未聚集的表产生的结果与之前是相同的。
The structure of the row locator depends on whether the data pages are stored in a heap or a clustered table.
行定位器的结构取决于数据页是存储在堆中还是聚集表中。
If the table is a range clustered table (that does not support row compression), you can consider switching it to become a range partitioned table (that supports row compression).
如果表是一个范围集群表(不支持行压缩),可以考虑将其变换为范围分区表(支持行压缩)。
If the table in your query are pretty small (usually fewer than 1,000 rows) or clustered tables, and your query is not selective at all, it would be beneficial to use a table scan.
如果查询中的表极其小(通常少于1,000行)或者是群集表,而且查询根本没有选择性的话,那么使用表扫描会更好一些。
A clustered table and a host of surprising results have led many to suggest the overall quality has dropped, but the Arsenal manager feels that, if anything, the calibre of the league has improved.
积分榜上的你追我赶的形势和一大把冷门的比赛结果,让很多人认为本赛季英超联赛的实力有所下降。但是温格教授认为,如果要究其原因的话,应该是英超联赛的实力提升了。
Because new rows are inserted in the part of the table that contains rows with similar values, data remains clustered without the need to run the REORG utility.
由于新行是插在表中具有近似值的行附近的位置,因此数据仍然是聚合的,而不需要运行REORG实用程序。
The index exploited for the inner table happens to be a clustered index.
利用内部表的索引恰好是一个聚集索引。
The costs of table scans can be fairly low if the data in the table is clustered or if it is in physical order.
如果表中的数据进行了群集化处理,或者是有物理次序的,那么表扫描的成本就可能相当低。
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.
然而,如果每个不同的索引值都有许多重复的行,而所关联的表是高度群集的,那么通过索引添加的连接成本可能很低。
Additional solutions, depending on the errors, may be to manually rebuild non-clustered indexes, manually drop and reload a table if the data is static, and so on.
另外的解决方案,取决于具体的错误,可能是手工重建非聚簇索引,如果数据是静态的手工扔掉和重新载入表,诸如此类。
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.
一般来说,如果内部索引是良好的集群且预测内部表被多次探测,则使用复合排序的嵌套循环联将受到优化器的青睐。
If typically more rows are accessed sequentially (maybe the table is clustered), then the larger page size is more efficient.
如果通常是顺序访问大量行(该表可能进行了群集),那么比较大的页大小会更有效。
With a sigh she walked back to her other students who were clustered at the back table patiently waiting her return.
她叹了口气,回到后排那一群正耐心等著她的学生。
With a sigh she walked back to her other students who were clustered at the back table patiently waiting her return.
她叹了口气,回到后排那一群正耐心等着她的学生。
Your clustered index is the order the data is stored in the table, so you can only have one clustered index per table.
你的聚集索引顺序表中的数据存储,所以你每个表只能有一个聚集索引。
The replay position advancement is necessary because the slow alter, alter fragment, and clustered index creation operations change the table partition Numbers.
重放位置的推进是必需的,因为slowalter、alterfragment和集群索引创建操作会改变表分区号。
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)。
The indexes that exist on a table, including the columns that they index, whether they are ascending or descending, and whether they are clustered.
存在于表上的索引,包括它们索引的列,哪些是升序或降序的,以及哪些是群集的。
It may also provide more accurate statistics if the data is clustered (obtains a sample that better represents overall table data).
如果数据是群集的,它还可以提供更准确的统计信息(所获得的样本更好地代表了整个表数据)。
Only one clustered index can exist per table.
对于每个表,只允许存在一个聚集索引。
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列和列上的聚集的索引设置转换过程中。
A table can contain only one clustered index.
一个表只能包含一个聚集索引。
A clustered index determines the order in which records are physically stored (which is why you can only have one per table).
聚集索引确定的顺序记录物理存储(这就是为什么你每个表只能有一个)。
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.
数据块的这部分包括了表和索引的数据。
应用推荐