> Fra: Fournier Jocelyn [Presence-PC] [mailto:[EMAIL PROTECTED]]
> Sendt: 14. april 2002 19:22

> In fact what it's odd is when I use EXPLAIN, I don't see anywhere DISTINCT
> in the EXPLAIN result :

That's because the MySQL optimizer converts your distinct into a group by.
Read more here:

http://www.mysql.com/doc/D/I/DISTINCT_optimisation.html

- Carsten



---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to