Constantin Lungudatawise.dev·Apr 2, 2024Why you should use UNION DISTINCT sparinglyLet's help BigQuery do less unneeded work! If you're UNIONING two sources known to have distinct values (and they don't have duplicates), go for UNION ALL instead of UNION DISTINCT (UNION for some other sql dialects) to avoid redundant de-duplication...49 readsPractical BigQuerySQLAdd a thoughtful commentNo comments yetBe the first to start the conversation.