Oracle 比较 B-tree 和 Bitmap 索引

发布日期：2025-04-29 13:58:52 浏览次数：13 分类：精选文章

本文共 1622 字，大约阅读时间需要 5 分钟。

Oracle????B-tree???Bitmap???????

???????Oracle???????????????????????B-tree???Bitmap?????????????????????????????????????????????

1. B-tree??

1.1 B-tree?????

B-tree????????????????????????????????????

???????????????????

????????????????? BETWEEN?LIKE???

?????????????????B-tree?????????????

1.2 B-tree?????

???????????????B-tree????????????????????

??????????????????????????

??????????????????????????????????????

1.3 B-tree?????

??????????B-tree????????????????????????

???????????????B-tree?????????????

2. Bitmap??

2.1 Bitmap?????

Bitmap????????????????????????????????????????

?????????????????

????????????????????????????????

??????????????????????????

2.2 Bitmap?????

??????????????????????????

??????????? LIKE? containment??????????

?????????????????????????????Bitmap???????????

2.3 Bitmap?????

???????Bitmap???????????????????

??????????????????????????

?????????????????????????????????

3. B-tree???Bitmap?????

???	B-tree??	Bitmap??
????	???????????	???????????????
??????	?????????	?????????
??????	????????????	?????????????
????	??????????????	???????????????
????	????????	??????

4. ????????

????????B-tree???Bitmap?????????????????????????????

4.1 ????

????????????100?????

?????

?????SELECT * FROM TESTIDX WHERE object_name = 'EMP'

?????SELECT * FROM TESTIDX WHERE object_type BETWEEN 'TABLE' AND 'VIEW'

?????SELECT * FROM TESTIDX WHERE object_name LIKE '%EMP%'

4.2 ????

????	B-tree??????	Bitmap??????
????	00:00:02	00:00:03
????	00:00:02	???
????	00:00:03	00:00:02

5. ??

???????B-tree???Bitmap?????????????????????????B-tree??????????????????????Bitmap?????????????????????????????????????????????????

上一篇：Oracle 注意点大全

下一篇：oracle 查询clob

发表评论

关于作者

喝酒易醉，品茶养心，人生如梦，品茶悟道，何以解忧？唯有杜康！

-- 愿君每日到此一游！