Re: SELECT DISTINCT too slow - Mailing list pgsql-sql

The GROUP BY is really fast :-)

Thank you.

Miroslav Šulc


Tom Lane napsal(a):
> Try
>     SELECT Key FROM MRTPContactValue GROUP BY Key
>
> The "select distinct" code is a bit old and crufty, GROUP BY is usually
> smarter.
>
>             regards, tom lane
>