Skip to Content

HANA Table statistics

Dec 13, 2017 at 07:04 PM


avatar image
Former Member


Is there a way to check they statistical details of usage for a given table.

We would like to see the data usage in all tables in our environment for a given period.

system table M_CS_ALL_COLUMNS has last accessed date information, but seems its not storing the history usage and user details. Also i couldn't identify weather table has been accessed by system or a user.. If we have a SLT enabled, then not sure if the table is accessed by system to replicate the data or a user has executed some data out of this table.

Thank you.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Amelia Yap
Jun 06 at 06:00 PM


You can check the monitoring view M_TABLE_STATISTICS for more details on table usage, or in the case of virtual tables, virtual table statistics are stored in the SYS.P_statistics_ system table. More information on system views can be found in the following reference guide:

In addition to these, you could also possibly also set up audit policies to check for specific actions related to accesses for tables:

Hope this helps!

Kind regards,


10 |10000 characters needed characters left characters exceeded