摘 要：指出了执行查询优化时，效果最显著的方法是使用 B 树索引，给出了使用 B 树索引的限制条件，分析了位图索引不同于 B 树索引的主要特点，以实例验证了位图索引存储的内容，得出了位图索引的结构。设计简洁的实验步骤，验证了使用位图索引对查询速度的提高幅度，以实例给出了位图索引所占空间的大小，最后给出了不适合使用位图索引的情况。
关键词：Oracle 数据库；位图索引；查询优化
DOI:10.19850/j.cnki.2096-4706.2021.08.045
中图分类号：TP311.13 文献标识码：A 文章编号：2096-4706（2021）08-0159-03
Principle and Application of Bitmap Index in Oracle Database
LI Aiwu
（Guangdong Vocational College of Post and Telecom，Guangzhou 510630，China）
Abstract：It is pointed out that the most effective way to perform query optimization is to use B-tree index，and the restrictions of using B-tree index are given. The main features of bitmap index that are different from B-tree index are analyzed，and the storage content of bitmap indexes is verified by examples，and obtains the structure of bitmap index. A concise experimental procedure is designed to verify the magnitude of improvement in query speed by using bitmap index. The size of space occupied by bitmap index is given with examples，and finally，the cases in which the use of bitmap indexes is not suitable are given.
Keywords：Oracle database；bitmap index；query optimization
参考文献：
[1] VAIDYANATHA G K，DESHPANDE K，JR J A k，et al. Oracle Performance Tuning 101 [M].Bangor：Osborne Media，2001.
[2] RICHARD N. Oracle 10g Database Performance Tuning Tips & Techniques [M].New Bangor：Osborne Media，2007.
[3] DONALD K，BURLESON. Oracle High Performance SQL Tuning [M].New York City： McGraw-Hill Education ，2001.
[4] CONWAY H，AULT M，BURLESON D. Oracle Tuning Power Tuning Scripts [M].Kittrell：Rampant Techpress，2005.
[5] LEWIS J. Cost-Based Oracle Fundamentals [M].[S.L]： Apress，2005.
[6] CELKO J. SQL for Smarties：Advanced SQL Programming [M].3rd ed.San Francisco：Morgan Kaufmann，2005.
作者简介：李爱武（1969.07—），男，河北肃宁人，副教授， 理学硕士，研究方向：数据库技术，数据分析。