#sqlcoalesce — Public Fediverse posts
Live and recent posts from across the Fediverse tagged #sqlcoalesce, aggregated by home.social.
-
What's wrong with this SQL COALESCE preventing index use?
What's wrong with this SQL COALESCE preventing index use. The SQL code filters with COALESCE(column, default). In MySQL functions on columns block indexes. In SQL the query scans the whole table.
#whatswrongwiththissqlquery #sqlbug #sqlproductionbug #sqldebugging #sqldatabase #sqlcodereview #sqlperformance #sqlreliability #sqlanalytics #sqldataintegrity #sqlengineering #sqlcoalesce #sqlind...
-
What's wrong with this SQL COALESCE preventing index use?
What's wrong with this SQL COALESCE preventing index use. The SQL code filters with COALESCE(column, default). In MySQL functions on columns block indexes. In SQL the query scans the whole table.
#whatswrongwiththissqlquery #sqlbug #sqlproductionbug #sqldebugging #sqldatabase #sqlcodereview #sqlperformance #sqlreliability #sqlanalytics #sqldataintegrity #sqlengineering #sqlcoalesce #sqlind...
-
What's wrong with this SQL COALESCE preventing index use?
What's wrong with this SQL COALESCE preventing index use. The SQL code filters with COALESCE(column, default). In MySQL functions on columns block indexes. In SQL the query scans the whole table.
#whatswrongwiththissqlquery #sqlbug #sqlproductionbug #sqldebugging #sqldatabase #sqlcodereview #sqlperformance #sqlreliability #sqlanalytics #sqldataintegrity #sqlengineering #sqlcoalesce #sqlind...