Back to VisualizerSQL Explain Example
mysql

MySQL UNION

Handling UNION operations with temporary tables.

SELECT id FROM users UNION SELECT id FROM archived_users;

UNION (without ALL) requires removing duplicates, so MySQL typically uses a temporary table to store intermediate results and verify uniqueness.

Interactive Execution Plan

EXPLAIN Output
Run: EXPLAIN FORMAT=JSON your_query; or EXPLAIN your_query;
Enter SQL EXPLAIN output to visualizeSupports PostgreSQL EXPLAIN ANALYZE, MySQL EXPLAIN, and SQLite EXPLAIN QUERY PLAN formats