How to Use SEMI JOIN to Replace Slow EXISTS

Optimizer can convert EXISTS to semi-join.

#mysql #semijoin #exists #performance #howto #optimizer

https://www.youtube.com/watch?v=8XgBaW-gDp0