BestHub
search
Sign in
Tag

internal temporary table

1 views collected around this technical thread.

Aikesheng Open Source Community
Aikesheng Open Source Community
Nov 7, 2023 · Databases

When Does MySQL Use Internal Temporary Tables? Analysis of UNION, GROUP BY and Other Scenarios

This article explains the circumstances under which MySQL creates internal temporary tables, illustrating the behavior with UNION, UNION ALL, GROUP BY, various hints, and additional query patterns, and provides practical examples and execution plans to help developers understand and optimise their queries.

GROUP BYMySQLPerformance
0 likes · 13 min read
When Does MySQL Use Internal Temporary Tables? Analysis of UNION, GROUP BY and Other Scenarios
Architect
Architect
Jul 1, 2016 · Databases

Two Types of Temporary Tables in MySQL and Their Usage

The article explains MySQL's external and internal temporary tables, describes ten scenarios where internal temporary tables are created—including hints, derived tables, ORDER BY, GROUP BY, IN‑subqueries, UNION and aggregates—and provides example SQL statements with EXPLAIN JSON output to illustrate performance impacts.

MySQLSQL Optimizationdatabase
0 likes · 10 min read
Two Types of Temporary Tables in MySQL and Their Usage