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 -> Re: speed up select distinct

Re: speed up select distinct

From: Dave <solomons_dad.w.marks_and_whom_at_oracle.com>
Date: Tue, 10 May 2005 11:05:46 +0100
Message-ID: <kZ%fe.18$622.77@news.oracle.com>

Tomislav Kokoska wrote:
> What is the best way to speed up query looks like:
>
> SELECT DISTINCT COLUMN1, COLUMN2, COLUMN3, COLUMN4 FROM TABLE WHERE COLUMN5
> = 5
>
>
>

Define "best." Received on Tue May 10 2005 - 05:05:46 CDT

Original text of this message

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