--- Al-Faisal El-Dajani <[EMAIL PROTECTED]> wrote:
> I was extremely > surprised to see the first > query (join) was actually FASTER than my second > query (nested). The only > thing i managed to conclude was that MySQL doesn't > support indices in inner > statements (not sure, if you have a better > explanation, please do share). mysql doesn't optimize subqueries, or as is it says in the docs "The optimizer is more mature for joins than for subqueries" http://dev.mysql.com/doc/refman/5.0/en/subquery-restrictions.html - Aram ____________________________________________________________________________________ Boardwalk for $500? In 2007? Ha! Play Monopoly Here and Now (it's updated for today's economy) at Yahoo! Games. http://get.games.yahoo.com/proddesc?gamekey=monopolyherenow --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Jolug" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/Jolug?hl=en-GB -~----------~----~----~----~------~----~------~--~---
