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 -> Performance of the "Select distinct"

Performance of the "Select distinct"

From: Nicolas Bronke <nbronke_at_ibm.net>
Date: Sun, 6 Dec 1998 14:54:22 +0100
Message-ID: <366a8c01.0@news2.ibm.net>


As I know, the command "select distinct" is not very fast. I may get the same result using following syntax like

select a,b,c, sum(0) from table
  group by a,d,c

In addition I receive the result set in order of a,b,c.

Is that faster?
--
Kind regards
Nicolas Bronke Received on Sun Dec 06 1998 - 07:54:22 CST

Original text of this message

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