#sqlfunctiononcolumn — Public Fediverse posts
Live and recent posts from across the Fediverse tagged #sqlfunctiononcolumn, aggregated by home.social.
-
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...
-
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...
-
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...