how to find frequently used data in a table of Teradata Database

General

how to find frequently used data in a table of Teradata Database

Hi All,

could you please tell me, how to find frequently used data in a table of Teradata Database?

Portions of data within tables that were accessed within last 2 years – Ex, if a table had 5 years of data and only 2years of data is being actively used, the plan is to archive the unused data.

Access count of dbc.tables is getting refreshed every 6 months and QRYLOG only having last 2 months of data.

Thanks,

Arka