How to get the last used time of table in SAP HANA

 

How to get the last used time of table in SAP HANA database.

This below query will work in both environment

• HANA 1.0
• HANA 2.0

 Execute the below query to get the last used time of HANA table in HANA database

• You can get the details from M_TABLE_STATISTICS and HANA_Tables_ColumnStore_Columns_LastTouchTime_*+.txt script.
• You can get the last touched time from those two columns from M_TABLE_STATISTICS.

LAST_MODIFY_TIME	TIMESTAMP	Displays the timestamp when the last INSERT, UPDATE, DELETE, or REPLACE statement was executed.
LAST_SELECT_TIME	TIMESTAMP	Displays the timestamp when the last SELECT statement was executed.