Query Store is useful for forcing a beneficial plan. What if something changes that makes the forced plan impossible to use? Let’s look at an example of that today.
Read on for an example. The answer is, I believe, the best possible outcome given the circumstances—certainly better than a hard failure.