Speed up Select distinct -
05-10-2005
, 04:13 AM
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?? |