Posted by gosha bine on 07/27/07 10:31

On 27.07.2007 11:46 Toby A Inkster wrote:
> gosha bine wrote:
>
>> Don't know about "most" ones, mysql docs explicitly says they're equivalent
>> http://dev.mysql.com/doc/refman/5.0/en/distinct-optimization.html
>
> It says that SELECT DISTINCT and GROUP BY *usually* end up generating the
> same execution plan, so there won't be a performance difference.
>

Pretending that you cannot read is probably the worst defense you could
come up with. ;)

--
gosha bine

makrell ~ http://www.tagarga.com/blok/makrell
php done right ;) http://code.google.com/p/pihipi

[Back to original message]