Why does this SQL JSON extract never use the index?
Why does this SQL JSON extract never use the index. The SQL code queries JSON with JSON_EXTRACT. In MySQL that cannot use a regular index. In SQL use a generated column with an index.
#whatswrongwiththissqlquery #sqlbug #sqlproductionbug #sqldebugging #sqldatabase #sqlcodereview #sqlperformance #sqlreliability #sqlanalytics #sqldataintegrity #sqlengineering #sqljson #sqljsonextract #sqlindex #sq...
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 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...
Why does this SQL json index fail?
Why does this SQL JSON index fail in production. The SQL code stores JSON as text and queries with LIKE, so indexes are never used. In SQL services this becomes a performance trap.
#whatswrongwiththissqlquery #sqlbug #sqlproductionbug #sqldebugging #sqldatabase #sqlcodereview #sqlperformance #sqlreliability #sqlanalytics #sqldataintegrity #sqlengineering #sqljson #sqlindex #sqlquery #sqloptimization
Why does this SQL index not get used?
Why does this SQL index not get used in production. The SQL query wraps the indexed column in a function, preventing index use. In SQL services this turns fast queries into table scans.
#whatswrongwiththissqlquery #sqlbug #sqlproductionbug #sqldebugging #sqldatabase #sqlcodereview #sqlperformance #sqlreliability #sqlanalytics #sqldataintegrity #sqlengineering #sqlindex #sqlfunctiononcolumn #sqlqueryplan #sqlo...
PrecisionSQL