Note that the full table scan is the lowest ranked access path on the list. This means that the RBO always chooses an access path that uses an index if one is available, even if a full table scan might execute faster.
从上面这段话我们知道full table scan 是最低等级的访问路径，那意味着下面列出来的15种访问路径的数字越小等级越高，也就是说使用访问路径的等级越高rbo认为效率越高，当然实际情况可能并非如此。[@more@]
Using the RBO, the optimizer chooses an execution plan based on the access paths available and the ranks of these access paths. Oracle's ranking of the access paths is heuristic. If there is more than one way to execute a SQL statement, then the RBO always uses the operation with the lower rank. Usually, operations of lower rank execute faster than those associated with constructs of higher rank.
The list shows access paths and their ranking:
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/19602/viewspace-1003210/，如需转载，请注明出处，否则将追究法律责任。