You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Problem:
When SP uses index and this index is deleted after the procedure was cached, SP can't execute.
Reason:
Procedure's optimized BLR resides in the metadata cache. To clear this cache, it's enough to disconnect all users from database. Recompilation is not necessary. It would be nice to allow re-optimization of cached SPs under some circumstances.
The text was updated successfully, but these errors were encountered:
Submitted by: @pcisar
Replaces CORE331
Problem:
When SP uses index and this index is deleted after the procedure was cached, SP can't execute.
Reason:
Procedure's optimized BLR resides in the metadata cache. To clear this cache, it's enough to disconnect all users from database. Recompilation is not necessary. It would be nice to allow re-optimization of cached SPs under some circumstances.
The text was updated successfully, but these errors were encountered: