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!