Table Versioning
An ALTER TABLE or ALTER STORAGE operation where the new policy increases the number of retention days results in a warning. To mitigate the risk of query failures due to the purger actively deleting versions that are referenced by SELECT..AS OF queries:
- Increase the number of retention days while the purger isn't running. Consider shutting down the purger, for example, prior to increasing retentiondays for the default system storage retention policy.
- Wait at least 24 hours before issuing SELECT..AS OF queries which might attempt to access old versions that could be affected.