Using Partitioned Indexes in OLTP Applications

Here are a few guidelines for OLTP applications:
■ Global indexes and unique, local indexes provide better performance than
nonunique local indexes because they minimize the number of index partition
probes.
■ Local indexes offer better availability when there are partition or
subpartition maintenance operations on the table.
■ Hash-partitioned global indexes offer better performance by spreading out
contention when the index is monotonically growing. In other words, most of the
index insertions occur only on the right edge of an index.

全域性索引和唯一的本地索引比非唯一的本地索引能提供更加好的效能
雜湊分割槽全域性索引能提供更加好的效能於索引單一增長的情況

[@more@]