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.
全局索引和唯一的本地索引比非唯一的本地索引能提供更加好的性能
哈希分区全局索引能提供更加好的性能于索引单一增长的情况
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/10599713/viewspace-1002306/ ，如需转载，请注明出处，否则将追究法律责任。
-
博文量740
-
访问量2002849
最新文章
- 人力&人手&人才&人物
- oracle树中prior的用法
- Using Supplied Packages to Manage Stored Outlines
- $ORACLE_HOMERDBMSADMIN目录下各SQL的含义
- PRODUCT_USER_PROFILE Table
- Backing Up Server Parameter Files with RMAN
- Backing Up Control Files with RMAN
- Backing Up Individual Tablespaces with RMAN
- Making Whole Database Backups with RMAN
- 目睹奥运火炬传递
