#sqlexplain — Public Fediverse posts
Live and recent posts from across the Fediverse tagged #sqlexplain, aggregated by home.social.
-
Why does this SQL EXPLAIN lie about the actual cost?
Why does this SQL EXPLAIN lie about the actual cost. The SQL code trusts EXPLAIN row estimates. In MySQL EXPLAIN shows estimates not reality. In SQL use EXPLAIN ANALYZE to see actual execution.
#whatswrongwiththissqlquery #sqlbug #sqlproductionbug #sqldebugging #sqldatabase #sqlcodereview #sqlperformance #sqlreliability #sqlanalytics #sqldataintegrity #sqlengineering #sqlexplain #sqlanalyze #sq...