Oracle 数据库的位图索引原理与应用  

Principle and Application of Bitmap Index in Oracle Database

作　　者：李爱武 LI Aiwu(Guangdong Vocational College of Post and Telecom,Guangzhou 510630,China)

机构地区：[1]广东邮电职业技术学院,广东广州510630

出　　处：《现代信息科技》2021年第8期159-161,共3页Modern Information Technology

摘　　要：指出了执行查询优化时,效果最显著的方法是使用B树索引,给出了使用B树索引的限制条件,分析了位图索引不同于B树索引的主要特点,以实例验证了位图索引存储的内容,得出了位图索引的结构。设计简洁的实验步骤,验证了使用位图索引对查询速度的提高幅度,以实例给出了位图索引所占空间的大小,最后给出了不适合使用位图索引的情况。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.

关 键 词：ORACLE数据库 位图索引 查询优化 

分 类 号：TP311.13[自动化与计算机技术—计算机软件与理论]