本文介绍了索引范围扫描这一数据库操作的基本概念，包括其不同形式（有界限与无界限）及数据返回方式。讨论了如何根据索引列的升序进行数据访问，并解释了ROWID在处理相同值时的作用。
Index range scan is a common operation for accessing selective data. It can be
bounded (bounded on both sides) or unbounded (on one or both sides). Data is
returned in the ascending order of index columns. Multiple rows with identical values
bounded (bounded on both sides) or unbounded (on one or both sides). Data is
returned in the ascending order of index columns. Multiple rows with identical values
are sorted (in ascending order) by the ROWIDs.
索引范围扫描是一个普通操作对于访问选择数据。它可以是有界限的（两边分界）或
者没有界限（一边或者是两边）。数据访问根据索引列的升序顺序。多行对于相同值的
排序是根据其ROWID的值过行升值排序
扫一扫
695
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
