Oracle FAQ

Your Portal to the Oracle Knowledge Grid

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US

Home -> Community -> Usenet -> c.d.o.misc -> speed up select distinct

speed up select distinct

From: Tomislav Kokoska <tkokoska_at_varteks.com>
Date: Tue, 10 May 2005 09:23:39 +0200
Message-ID: <d5pniu$97$1@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 Received on Tue May 10 2005 - 02:23:39 CDT

This message: [ Message body ]
Next message: Andreas Mosmann: "Re: ORA-16068: redo log file activation identifier mismatch"
Previous message: DA Morgan: "Re: Need SQL help on updating a table from another table"
Next in thread: Dave: "Re: speed up select distinct"
Reply: Dave: "Re: speed up select distinct"
Reply: DA Morgan: "Re: speed up select distinct"
Reply: Tomislav Kokoska: "Re: speed up select distinct"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US