Tom-196419
SSC Veteran
Points: 201
More actions
July 29, 2019 at 7:24 am
#3666694
Hi
Are there cases or situations during which the manually forced plan can be unforced without manual intervention ?
Thank You
Grant Fritchey
SSC Guru
Points: 398909
July 29, 2019 at 12:07 pm
#3666754
Yes. If anything has changed in the structures such that the forced plan is no longer valid, it'll just get ignored.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"- Theodore Roosevelt
Author of:SQL Server Execution PlansSQL Server Query Performance Tuning
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply