Conclusions
•Although purging old data
should have almost no effect on day-to-day performance if
the application is well-designed and the query execution
plans are well-tuned and robust, correctly designed applications
and processes should almost never touch old data,
making such purges relatively safe and easy.
•A “read trigger” would be a
useful innovation, here – “Notify me if, contrary to
expectations, anyone ever reads these rows…”