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)