MySQL Forums
Forum List  »  Optimizer & Parser

Re: Query not using index sporadically
Posted by: Rick James
Date: June 18, 2014 02:48PM

Do you really need RIGHT JOIN instead of plain JOIN? That effectively forces it to start with the RIGHT table (rluf), which makes it impossible to consider the WHERE clause soon enough to be always efficient.

Question: Does the EXPLAIN depend on whether these values exist in user_id??
WHERE `rlbl`.`user_id` IN ( 'kjsdhjs5354bkdf', 'kjbsdkbsd232323' )

Please provide the EXPLAINs.

Options: ReplyQuote

Written By
June 13, 2014 07:51AM
Re: Query not using index sporadically
June 18, 2014 02:48PM

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.