[prev] 45 [next]

Exercise 4: Bitmap Index

Using the following file structure:

[Diagram:Pics/select/bitmap-index.png]

Show how the following queries would be answered: 

select * from Parts
where colour='red' and price < 4.00

select * from Parts
where colour='green' or colour ='blue'