本文共 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?????

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 ????

5. ??

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

转载地址：http://xapfk.baihongyu.com/