MySQL Subquery Optimization Strategies and Rewriting DELETE with JOIN

This article explains why a DELETE statement with a sub‑query can cause a full‑table scan in MySQL, describes the optimizer's semijoin, materialization and exists strategies for different sub‑query types, and shows how to rewrite the statement using a JOIN for better performance.

DELETEJOINSubquery

0 likes · 9 min read

MySQL Subquery Optimization Strategies and Rewriting DELETE with JOIN

Tencent Database Technology

Apr 18, 2019 · Databases

MySQL Execution Process and SemiJoin Optimization Techniques

This article explains MySQL's execution stages, defines SemiJoin, details how IN subqueries can be transformed into SemiJoin queries, outlines conversion constraints, provides example transformations, and describes the various execution strategies MySQL may use for SemiJoins.

databasemysqlquery optimization

0 likes · 13 min read

MySQL Execution Process and SemiJoin Optimization Techniques