3 ms·
Must not have been working with it very long, off the top of my head having to disable the "new" optimizer in Sql 2014 and go back to the 2012 version due to ba
by SigmundA 5y ago
Must not have been working with it very long, off the top of my head having to disable the "new" optimizer in Sql 2014 and go back to the 2012 version due to bad plans https://sqlservergeeks.com/sql-server-2014-trace-flags-9481/ https://sqlservergeeks.com/sql-server-2014-trace-flags-9481/
I have been working with it since way back in 6.5 and it has made many obviously wrong decisions in the optimizer over the years, its has gotten better but is by no means perfect, good thing is it has hints unlike PG!
- slt2021 5y agoSo whats the issue with marginal difference in cardinality estimators? Both queries seem perfectly fine speed-wise. Just splitting hairs, again most of the time developers fail to notice the significant data distribution drift, and dont rearchitect their data models then blame the engine for developers omissions and invalid assumptions
- SigmundA 5y agohttps://www.sqlconsulting.com/archives/big-performance-problems-with-the-cardinality-estimator/ https://www.sqlconsulting.com/archives/big-performance-probl...