3 ms·
Hah, if versions were enough for consistent performance I'd be in heaven. I'm plagued by cases where the same schema with the same indices on same version of s
by Pxtl 7y ago
Hah, if versions were enough for consistent performance I'd be in heaven.
I'm plagued by cases where the same schema with the same indices on same version of servers running on the same architecture gets different plans and performance.
- wbl 7y agoRegather the table statistics. If it was the same data I'd be shocked, but this isn't that surprising.
- DougBTX 7y agoFor SQL Server there’s a very nice article on making query plans more predictable here: http://www.sommarskog.se/query-plan-mysteries.html http://www.sommarskog.se/query-plan-mysteries.html