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和导入上。