Execution Plan changes between good and bad query plans (Azure SQL Server)
3
votes
0
answers
343
views
I've done my best to follow https://dba.stackexchange.com/questions/204565/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!
Asked by Vince
(175 rep)
Jul 25, 2022, 03:49 PM
Last activity: Jul 25, 2022, 11:54 PM
Last activity: Jul 25, 2022, 11:54 PM