Speed up Select distinct
From: Tomislav Kokoska <tkokoska_at_varteks.com>
Date: Tue, 10 May 2005 11:13:28 +0200
Message-ID: <d5pu0r$d5l$1_at_ss405.t-com.hr>
What is the best way to speed up query looks like:
Date: Tue, 10 May 2005 11:13:28 +0200
Message-ID: <d5pu0r$d5l$1_at_ss405.t-com.hr>
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 - 11:13:28 CEST