Two Servers. Two radically different plans.
2017-08-17 21:40:43
Query on production server is 10 times slower than development server. Identical schemas and data.
This is the slow query plan .pesession file.
2017-08-17 23:18:12
Fast query plan
I would like to tune this without resorting to forcing a plan. The production server insists on using the slower query plan.
Any help is greatly appreciated.
Thanks.