#sqlunion — Public Fediverse posts
Live and recent posts from across the Fediverse tagged #sqlunion, aggregated by home.social.
-
Why does this SQL UNION sort when you did not ask?
Why does this SQL UNION sort when you did not ask. The SQL code uses UNION to combine results. In SQL UNION implies DISTINCT and sorts to dedupe. In SQL that is expensive. Use UNION ALL when dupes are fine.
#whatswrongwiththissqlquery #sqlbug #sqlproductionbug #sqldebugging #sqldatabase #sqlcodereview #sqlperformance #sqlreliability #sqlanalytics #sqldataintegrity #sqlengineering #sqlunion #sqlun...
-
Why does this SQL UNION sort when you did not ask?
Why does this SQL UNION sort when you did not ask. The SQL code uses UNION to combine results. In SQL UNION implies DISTINCT and sorts to dedupe. In SQL that is expensive. Use UNION ALL when dupes are fine.
#whatswrongwiththissqlquery #sqlbug #sqlproductionbug #sqldebugging #sqldatabase #sqlcodereview #sqlperformance #sqlreliability #sqlanalytics #sqldataintegrity #sqlengineering #sqlunion #sqlun...