I forgot to mention that any other operation that examines every table row will fix all the hint bits as well. In particular a CREATE INDEX would do that ---
I might be missing something, but I think CREATE INDEX work on SnapshotAny and hence may not actually examine any table row ?