3

I've done my best to follow Why is my query suddenly slower than it was yesterday?

The ShowPlanXML parses fine with SQL Sentry Plan Explorer but not via brentozar.com/pastetheplan (not sure why) so I have pasted text files to my github instead below:

Here is the DDL and TSQL I am executing.

Here is the bad query plan (times out). PasteThePlan

Here is the good query plan. PasteThePlan

Any idea how I can more reliably get the engine to use a "good" query plan? Thank you!

Charlieface
  • 17,078
  • 22
  • 44
Vince
  • 175
  • 3

0 Answers0