(Rob Gravelle) One of MySQL 5.6’s many optimizations apply to the processing of queries that contain subqueries. These involve transforming a subquery into a semi-join operation, and then treating it like just another join operation for evaluation.
Read More - Register for Free Membership
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help