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.
Subject
Views
Written By
Posted
6806
September 02, 2009 06:24PM
2723
September 03, 2009 12:28AM
2828
September 03, 2009 05:31PM
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.