How to find most used Base Table in last one month to verify data cleanups and purge in SAP HANA

[Former Member]

Hi Folks,

are there any reports/tools or SQL available that help to identify most used Tables and view in HANA?

We are looking to Purge Table which are not used for Reporting.

Need to find most used Tables.

Large Table which not used in last one month or old.

In all Schema.

Thanks

Ravindar

[Former Member]

You can e.g. use SQL: "HANA_Tables_ColumnStore_Columns_LastAccessTime" (SAP Note 1969700) to identify columns not being accessed for a long time and determine table candidates based on this information. The overall largest tables can be identified via SQL: "HANA_Tables_LargestTables" (SAP Note 1969700).