Two Servers. Two radically different plans.

RobertU 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.

RobertU 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.