#sqlor — Public Fediverse posts
Live and recent posts from across the Fediverse tagged #sqlor, aggregated by home.social.
-
What's wrong with this SQL OR killing the index?
What's wrong with this SQL OR killing the index on a search. The SQL code uses OR on two indexed columns. In MySQL OR often prevents index usage. In SQL APIs one OR turns a millisecond query into seconds.
#whatswrongwiththissqlquery #sqlbug #sqlproductionbug #sqldebugging #sqldatabase #sqlcodereview #sqlperformance #sqlreliability #sqlanalytics #sqldataintegrity #sqlengineering #sqlor #sqlindex #sq...
-
What's wrong with this SQL OR killing the index?
What's wrong with this SQL OR killing the index on a search. The SQL code uses OR on two indexed columns. In MySQL OR often prevents index usage. In SQL APIs one OR turns a millisecond query into seconds.
#whatswrongwiththissqlquery #sqlbug #sqlproductionbug #sqldebugging #sqldatabase #sqlcodereview #sqlperformance #sqlreliability #sqlanalytics #sqldataintegrity #sqlengineering #sqlor #sqlindex #sq...
-
What's wrong with this SQL OR killing the index?
What's wrong with this SQL OR killing the index on a search. The SQL code uses OR on two indexed columns. In MySQL OR often prevents index usage. In SQL APIs one OR turns a millisecond query into seconds.
#whatswrongwiththissqlquery #sqlbug #sqlproductionbug #sqldebugging #sqldatabase #sqlcodereview #sqlperformance #sqlreliability #sqlanalytics #sqldataintegrity #sqlengineering #sqlor #sqlindex #sq...