Re: Query not using index sporadically

[Rick James]

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.