> On Mar 12, 2024, at 07:15, Dominique Devienne <ddevienne@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
sometype 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.