Sometimes we write data that we expect not to need to read back again any time soon, so it might be helpful to have a hint we can pass to set the retention priority for that data in the cache to be low, similar to "read once" hints used for scans.

This idea came up in the context of brainstorming how to mitigate cache effects from the additional writes performed by index builds.