Erin Stellato explains how Query Store works when you have encrypted stored procedures:
There are two issues here:
– Why are only some plans showing up in Query Store for a query that’s part of an encrypted stored procedure?
– Can I force a plan for a query that’s part of an encrypted stored procedure?When in doubt, test.
Read on for the results.