Tagged articles

correlated subquery

3 articles · Page 1 of 1

Sep 28, 2026 · Databases

8 SQL Anti-Patterns That Kill Performance (and How to Fix Them)

This article details eight common SQL anti-patterns — including OFFSET pagination, implicit type conversion, correlated subqueries in updates, mixed sorting, EXISTS clauses, blocked condition pushdown, late filtering, and unoptimized intermediate results — with execution plans and rewrites that reduce query times from seconds to milliseconds.

CTEMySQLSQL optimization

0 likes · 16 min read

8 SQL Anti-Patterns That Kill Performance (and How to Fix Them)

Tech Musings

Sep 7, 2026 · Databases

MySQL Subquery Column Name Escaping: Silent Full-Table Update/Delete Risk

MySQL silently resolves missing column names in subqueries to outer scope columns, turning filters into correlated subqueries that always evaluate true, causing full-table updates or deletes without errors or warnings; no sql_mode prevents this behavior.

MySQLbest practicescolumn resolution

0 likes · 10 min read

MySQL Subquery Column Name Escaping: Silent Full-Table Update/Delete Risk

Alibaba Cloud Developer

Mar 29, 2021 · Databases

Mastering Correlated Subqueries: Decorrelation, Push‑Down Rules, and Optimization Techniques

This article explains what correlated subqueries are, why they challenge database engines, and how they can be transformed into ordinary SQL using decorrelation, push‑down rules, result reuse, and window‑function tricks, illustrated with TPCH examples and code snippets.

DecorrelationSQLcorrelated subquery

0 likes · 24 min read

Mastering Correlated Subqueries: Decorrelation, Push‑Down Rules, and Optimization Techniques