MySQL :: MySQL 5.0 Reference Manual :: 8.3.1.7 LEFT JOIN and RIGHT JOIN Optimization

got the same pb as Mark Malakanov and the same solution - extremely slow query during a left outer join...it happens that the join was done on one column defined with CHARACTER SET utf8 COLLATE utf8_bin and the other one without character set ...

dev.mysql.com