ITPub博客

首页 > 数据库 > Oracle > Performance and Storage Considerations (217)

Performance and Storage Considerations (217)

原创 Oracle 作者:tsinglee 时间:2007-11-18 13:38:12 0 删除 编辑

Key compression can lead to a huge saving in space, letting you store more keys in
each index block, which can lead to less I/O and better performance.

Although key compression reduces the storage requirements of an index, it can
increase the CPU time required to reconstruct the key column values during an index
scan. It also incurs some additional storage overhead, because every prefix entry has
an overhead of 4 bytes associated with it.

性能以及存储上的考虑
1. 可以在索引块中存储跟过的索引键 ,减少I/O ,提高性能 ,节省空间
2. 当执行索引扫描时 ,要重构键值 ,因此增加了 CPU 的负担
3. 键压缩也会导致额外的存储开销 ,因为每个前缀需要4字节的管理开销

[@more@]

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/10599713/viewspace-982905/,如需转载,请注明出处,否则将追究法律责任。

下一篇: What Is OC4J
请登录后发表评论 登录
全部评论
  • 博文量
    740
  • 访问量
    1892229