Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Performance of the "Select distinct"
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