MySQL Forums
Forum List  »  Performance

Re: Performance of WHERE EXISTS query
Posted by: Rick James
Date: September 04, 2009 07:29PM

I'm pretty sure EXISTS ( SELECT * ... ) is optimized so the * does not matter. Still...

Usually MySQL optimizes JOIN (and LEFT JOIN) much better than subqueries.

Options: ReplyQuote


Subject
Views
Written By
Posted
6806
September 02, 2009 06:24PM
Re: Performance of WHERE EXISTS query
2411
September 04, 2009 07:29PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.