MySQL Forums
Forum List  »  Performance

Re: Difference execution plans for same query
Posted by: Rick James
Date: March 05, 2016 01:19AM

Are the datasets on the two machines identical (or nearly so)? Significant differences in the data, especially for that date range, could easily lead to different explain plans.

Differences in the constants in the query can also lead to different plans. I have seen as many as 6 different plans for the similar queries on the same machine.

Options: ReplyQuote

Written By
Re: Difference execution plans for same query
March 05, 2016 01:19AM

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.