#sqlwildcard — Public Fediverse posts
Live and recent posts from across the Fediverse tagged #sqlwildcard, aggregated by home.social.
-
What's wrong with this SQL LIKE forcing a full scan?
What's wrong with this SQL LIKE forcing a full scan on a search. The SQL code uses LIKE with a leading wildcard. In MySQL that cannot use an index. In SQL one search scans millions of rows.
#whatswrongwiththissqlquery #sqlbug #sqlproductionbug #sqldebugging #sqldatabase #sqlcodereview #sqlperformance #sqlreliability #sqlanalytics #sqldataintegrity #sqlengineering #sqllike #sqlwildcard #sqlindex...
-
What's wrong with this SQL LIKE forcing a full scan?
What's wrong with this SQL LIKE forcing a full scan on a search. The SQL code uses LIKE with a leading wildcard. In MySQL that cannot use an index. In SQL one search scans millions of rows.
#whatswrongwiththissqlquery #sqlbug #sqlproductionbug #sqldebugging #sqldatabase #sqlcodereview #sqlperformance #sqlreliability #sqlanalytics #sqldataintegrity #sqlengineering #sqllike #sqlwildcard #sqlindex...
-
What's wrong with this SQL LIKE forcing a full scan?
What's wrong with this SQL LIKE forcing a full scan on a search. The SQL code uses LIKE with a leading wildcard. In MySQL that cannot use an index. In SQL one search scans millions of rows.
#whatswrongwiththissqlquery #sqlbug #sqlproductionbug #sqldebugging #sqldatabase #sqlcodereview #sqlperformance #sqlreliability #sqlanalytics #sqldataintegrity #sqlengineering #sqllike #sqlwildcard #sqlindex...