Reverse Key Indexes【每日一译】--20121224

Creating a reverse key index, compared to a standard index, reverses the bytes of each
column indexed (except the rowid) while keeping the column order. Such an

arrangement can help avoid performance degradation with Real Application Clusters

where modifications to the index are concentrated on a small set of leaf blocks. By
reversing the keys of the index, the insertions become distributed across all leaf keys in
the index.

创建一个反向键索引，对比于其它标准索引，反向每个被索引列的字节顺序（除了ROWID的值）

同时要保持列的顺序。这么一个布置可以帮我们避免性能的下降在使用RAC时，它对于索引的修改

被集中在一个小的叶块集合中。通过反向索引的主键，插入将会变成分布地跨越所有的叶结点主键在

索引中。

Using the reverse key arrangement eliminates the ability to run an index range
scanning query on the index. Because lexically adjacent keys are not stored next to
each other in a reverse-key index, only fetch-by-key or full-index (table) scans can be
performed.
Sometimes, using a reverse-key index can make an OLTP Real Application Clusters
application faster. For example, keeping the index of mail messages in an e-mail
application: some users keep old messages, and the index must maintain pointers to
these as well as to the most recent.

使用反向键布置消除了使用索引进行范围扫描的能力。因为语义上相领的主键彼此之间

不在下一个位置有一个反向键索引，仅按主键获取或者全索引扫描可以被执行。

一些时候，使用反向键索引可以使得OLTP的RAC应用更快的性能。比如，一个发送消息的索引

保留在一个E-MAIL应用中：一个用户保留老信息，并且索引必须维护指针到这些最近使用的消息中。

The REVERSE keyword provides a simple mechanism for creating a reverse key index.
You can specify the keyword REVERSE along with the optional index specifications in
a CREATE INDEX statement:
CREATE INDEX i ON t (a,b,c) REVERSE;
You can specify the keyword NOREVERSE to REBUILD a reverse-key index into one
that is not reverse keyed:
ALTER INDEX i REBUILD NOREVERSE;
Rebuilding a reverse-key index without the NOREVERSE keyword produces a rebuilt,
reverse-key index.

反向键关键词提供了一个简单的机制对于创建一个反向键的索引。你可以指定关键词REVERSE

使用额外的索引指定在一个CREATE INDEX语句中：

。。。。。

你可以指定产键词NOREVERSE去重建一个反向键索引到一个没有反向键索引。

******

重建一个反向键索引没有NOREVERSE关键字产生了重建，将产生反向键索引。