Oracle Compressed Indexes

最新推荐文章于 2025-09-08 20:55:49 发布

转载最新推荐文章于 2025-09-08 20:55:49 发布 · 77 阅读

文章标签：

#数据库

本文介绍了如何使用压缩索引来高效地对低基数列进行索引，这种方法可以减少所需的索引叶块数量，从而提高插入语句的速度并加速全索引扫描，同时节省存储空间。

Key compressed indexes are a way to index a low cardinality column without talking up as much space storing the repetitive values. Please view the Oracle Manuals for a full description on implementing compressed indexes.

Benefits

Fewer index leaf blocks need to be read since more rows fit into fewer blocks
Insert statements are faster since fewer leaf blocks need to be read to determine where the new row is inserted
Faster full index scans due to fewer leaf blocks
Space savings

关注博主即可阅读全文