#sqldatain — Public Fediverse posts
Live and recent posts from across the Fediverse tagged #sqldatain, aggregated by home.social.
-
Why does this SQL prepared statement reuse the wrong plan?
Why does this SQL prepared statement reuse the wrong plan. The SQL code uses a prepared statement with different param values. In MySQL the first execution picks a plan. In SQL later values may need a different plan but get the wrong one.
#whatswrongwiththissqlquery #sqlbug #sqlproductionbug #sqldebugging #sqldatabase #sqlcodereview #sqlperformance #sqlreliability #sqlanalytics #sqldatain...
-
Why does this SQL prepared statement reuse the wrong plan?
Why does this SQL prepared statement reuse the wrong plan. The SQL code uses a prepared statement with different param values. In MySQL the first execution picks a plan. In SQL later values may need a different plan but get the wrong one.
#whatswrongwiththissqlquery #sqlbug #sqlproductionbug #sqldebugging #sqldatabase #sqlcodereview #sqlperformance #sqlreliability #sqlanalytics #sqldatain...
-
Why does this SQL prepared statement reuse the wrong plan?
Why does this SQL prepared statement reuse the wrong plan. The SQL code uses a prepared statement with different param values. In MySQL the first execution picks a plan. In SQL later values may need a different plan but get the wrong one.
#whatswrongwiththissqlquery #sqlbug #sqlproductionbug #sqldebugging #sqldatabase #sqlcodereview #sqlperformance #sqlreliability #sqlanalytics #sqldatain...