Login | Register
[+/-]
FROM
EXISTS
The MySQL query optimizer has different strategies available to evaluate subqueries. For IN (or =ANY) subqueries, the optimizer has these choices:
IN
=ANY
Semi-join
Materialization
EXISTS strategy
For NOT IN (or <>ANY) subqueries, the optimizer has these choices:
NOT IN
<>ANY
The following sections provide more information about these optimization strategies.
Add your own comment.
© 2013, Oracle Corporation and/or its affiliates
User Comments
Add your own comment.