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