Skip to Content
Technical Articles
Author's profile photo Rajarajeswari Kaliyaperumal

How to find historic record count of column table using :_SYS_STATISTICS.HOST_COLUMN_TABLES_PART_SIZE

HISTORIC RECORD COUNT USING _SYS_STATISTICS.HOST_COLUMN_TABLES_PART_SIZE

If you have ever wondered how to find the historic row count of any column store table in HANA, this email will help you out!

WAY1 :Execute the below SQL which uses _SYS_STATISTICS.HOST_COLUMN_TABLES_PART_SIZE

select table_name,max(record_count),min(record_count),max(RAW_RECORD_COUNT_IN_MAIN),min(RAW_RECORD_COUNT_IN_MAIN),year(snapshot_id) YEAR,month(snapshot_id) MONTH,dayofmonth(snapshot_id) DAY

 from _SYS_STATISTICS.HOST_COLUMN_TABLES_PART_SIZE

  where table_name=’<TABLE_NAME>

  group by year(snapshot_id),month(snapshot_id),dayofmonth(snapshot_id),table_name

  order by year(snapshot_id),month(snapshot_id),dayofmonth(snapshot_id);

 

 

Way 2:Use the SQL:HANA_Tables_TopGrowingTables_Records_History from OSS: 1969700

Download the specified OSS and make the changes as per requirement in modification section.

Modify date as well:

Output:

 

Hope it was helpful!!
Click on like if you found this article useful and FOLLOW for more such articles!https://people.sap.com/rajarajeswari_kaliyaperumal
Please leave a comment or suggestion!

 

 

Assigned Tags

      1 Comment
      You must be Logged on to comment or reply to a post.
      Author's profile photo Parag Jain
      Parag Jain

      Thank you for the blog. Which column should be used for determining the memory size ? Just like you have max/min for record count.

       

      Regards, Parag