MySQL Forums
Forum List  »  Optimizer & Parser

Re: single sweep multi join in combination with where
Posted by: Rick James
Date: August 31, 2008 11:57PM

1. See if you get any clues from EXPLAIN EXTENDED.

2. Probably no difference, since the optimizer will realize that your queries are equivalent. I think it will do the optimal thing in both cases.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: single sweep multi join in combination with where
2335
August 31, 2008 11:57PM


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.