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
devrim@oper.metu.edu.tr Tel : (312) 295 9318
devrim.gunduz@linux.org.tr Faks : (312) 295 9494
Web : http://devrim.oper.metu.edu.tr -------------------------------------