Speed up Select distinct

comp.databases.oracle comp.databases.oracle

Thread Tools

Display Modes

Tomislav Kokoska

Posts: n/a

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??

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off