Can adding an index make a non SARGable query SARGable?

Re:Can adding an index make a non SARGable query SARGable? by Pxtl on Saturday October 19, 2019 @12:50AM (#21296807)

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.

[ Parent | on HN ]

Re:Can adding an index make a non SARGable query SARGable? by DougBTX on Sunday October 20, 2019 @04:34AM (#21302910)

For SQL Server there’s a very nice article on making query plans more predictable here: http://www.sommarskog.se/query-plan-mysteries.html

[ Parent | on HN ]

Re:Can adding an index make a non SARGable query SARGable? by wbl on Saturday October 19, 2019 @02:14AM (#21297075)

Regather the table statistics. If it was the same data I'd be shocked, but this isn't that surprising.

[ Parent | on HN ]