Skip to content
Tagged articles

subquery optimization

4 articles · Page 1 of 1
Architect's Guide
Architect's Guide
Oct 9, 2026 · Databases

SQL Optimization: From 30,248s to 0.001s

A step-by-step MySQL query optimization case study showing how indexing, join rewriting, composite indexes, and covering indexes reduced execution time from 30,248 seconds to 0.001 seconds with execution plan analysis.

Composite IndexCovering IndexMySQL
0 likes · 12 min read
SQL Optimization: From 30,248s to 0.001s
Java Architecture Stack
Java Architecture Stack
Dec 23, 2024 · Databases

10 Real-World MySQL Subquery Optimizations to Boost Performance

This article explains why MySQL subqueries can hurt performance, outlines common pitfalls such as temporary tables, index loss, and optimizer complexity, and presents ten concrete examples that replace subqueries with IN, EXISTS, JOIN, indexes, temporary tables, window functions, and LIMIT to achieve faster, more maintainable queries.

MySQLSQL Performancedatabase tuning
0 likes · 10 min read
10 Real-World MySQL Subquery Optimizations to Boost Performance