Speed up Select distinct

[Tomislav Kokoska]

What is the best way to speed up query looks like:

SELECT DISTINCT COLUMN1, COLUMN2, COLUMN3, COLUMN4 FROM TABLE WHERE COLUMN5
= 5

cardinality of Column5 = 10
will create bitmap index o n column5 help to speed up above query??