分类: Oracle
2010-11-01 15:26:51
The numbers will end up 'far away' from each other. This reduces the number of instances going after the same block (the leftmost block) and reduces the amount of pinging going on. One of the drawbacks to a reverse key index is that you cannot utilize it in all of the cases where a regular index can be applied. For example, in answering the following predicate, a reverse key index on x would not be useful:
where x > 5
The data in the index is not sorted before it is stored, hence the range scan will not work.
chinaunix网友2010-11-01 17:50:25
很好的, 收藏了 推荐一个博客,提供很多免费软件编程电子书下载: http://free-ebooks.appspot.com