> On Mar 12, 2024, at 07:15, Dominique Devienne <ddevie...@gmail.com> wrote:
> So is it possible to track the last time a SELECT was performed on some TABLE?
Directly, no. You could periodically sample the various table-level
statistics, and conclude that tables that have had some type of scan since the
last scan have had a SELECT run against them. It might not be 100% accurate if
(for example) you reset the statistics or lose them for some other reason, but
it might be sufficient for the application.
