SQL Practice Logo

SQLPractice Online

Level 7 - ArchitectOptimization Questionsm2 query shape optimization

Optimization Showdown: UNION vs UNION ALL

Choose better query for append-only event union where duplicates are acceptable. Query A: SELECT user_id FROM mobile_events UNION SELECT user_id FROM web_events; Query B: SELECT user_id FROM mobile_events UNION ALL SELECT user_id FROM web_events;

Schema Context

mobile_events(user_id), web_events(user_id)