彻底搞懂反转索引

最新推荐文章于 2022-06-17 13:37:50 发布

scan724

最新推荐文章于 2022-06-17 13:37:50 发布

阅读量2.8k

点赞数

分类专栏： Oracle dump解析

本文链接：https://blog.csdn.net/zhaoyangjian724/article/details/26622161

版权

Oracle dump解析专栏收录该内容

34 篇文章 31 订阅 ¥49.90 ¥99.00

订阅专栏

超级会员免费看

反转索引是一种特殊的索引类型，尤其适用于避免在Oracle RAC环境中因序列产生的索引导致的热块争用。通过翻转索引列的字节，插入操作得以均匀分布到所有叶子块，消除索引范围扫描，只支持通过键或全索引扫描。本文通过创建测试表并应用反转索引，展示了如何分布插入并分析索引结构，以验证反转索引如何打散热点，改善性能。

摘要由CSDN通过智能技术生成

<pre name="code" class="sql">Reverse Key Indexes

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.

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

了解本专栏