Sample Header Ad - 728x90

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