Tagged articles

Subquery Optimization

3 articles · Page 1 of 1

Feb 22, 2026 · Databases

Why Is Your SQL Slow? Deep Dive into Common MySQL Slow Query Patterns and Optimizations

This guide explains how to configure MySQL's slow query log, use pt‑query‑digest to analyze logs, identifies common slow‑query patterns such as full table scans, large sorts, N+1 queries, implicit type conversion and bad joins, and provides concrete rewrite and indexing techniques to optimize each case.

MySQLSlow QuerySubquery Optimization

0 likes · 12 min read

Why Is Your SQL Slow? Deep Dive into Common MySQL Slow Query Patterns and Optimizations

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.

JOINMySQLSQL Performance

0 likes · 10 min read

10 Real-World MySQL Subquery Optimizations to Boost Performance

Aikesheng Open Source Community

Sep 21, 2020 · Databases

Understanding Semi‑join Materialization in MySQL Subquery Optimization

This article explains how MySQL transforms eligible subqueries into semi‑joins, describes the four semi‑join strategies, and details the Semi‑join Materialization approach—including Materialization‑scan and Materialization‑lookup—while showing how to identify the chosen strategy via EXPLAIN output.

Database PerformanceMySQLSemi-Join

0 likes · 9 min read

Understanding Semi‑join Materialization in MySQL Subquery Optimization