Speed up Select distinct

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?? Received on Tue May 10 2005 - 04:13:28 CDT