Bitmap indexing benefits data warehousing applications which have large amounts of
data and ad hoc queries but a low level of concurrent transactions. For such
applications, bitmap indexing provides:
■ Reduced response time for large classes of ad hoc queries
■ A substantial reduction of space use compared to other indexing techniques
■ Dramatic performance gains even on very low end hardware
■ Very efficient parallel DML and loads
位图索引适应用数据仓库应用,这应用拥有大的数据量和热点查询。但要低级别的并发
事务量。对于这样的应用,位图索引提供了:
#减少对于热点大量级查询的反应时间
#大量减少空间使用对比于其它索引技术
#吸引人的性能甚至在低级别的硬件上
#非常有效在并行DML和导入上。