[SQL] performance comparison: DISTINCT and GROUP BY

[Devrim GUNDUZ]

Hi,

We have two different queries:

 SELECT name,surname  FROM my_table GROUP BY name;

and

 SELECT DISTINCT on(name) name,surname  * FROM my_table;

which gives us the same result.

Do these queries differ by their performances? I mean, which one works 
faster? DISTINCT or GROUP BY?

Best regards.

-- 

Devrim GUNDUZ

[EMAIL PROTECTED]                 Tel  : (312) 295 9318
[EMAIL PROTECTED]              Faks : (312) 295 9494

                Web : http://devrim.oper.metu.edu.tr
                -------------------------------------


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])