#sqloptimizer — Public Fediverse posts
Live and recent posts from across the Fediverse tagged #sqloptimizer, aggregated by home.social.
-
Why does this SQL STRAIGHT_JOIN make it worse?
Why does this SQL STRAIGHT_JOIN make it worse. The SQL code forces join order with STRAIGHT_JOIN. In MySQL you override the optimizer. In SQL the wrong order can be orders of magnitude slower.
#whatswrongwiththissqlquery #sqlbug #sqlproductionbug #sqldebugging #sqldatabase #sqlcodereview #sqlperformance #sqlreliability #sqlanalytics #sqldataintegrity #sqlengineering #sqlstraightjoin #sqloptimizer #sq...