> 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