Sap Hana - Row tables

Load status

Standard row tables are loaded into memory when the database is started and remain there as long as it is running.

Partitioning

Partitioning is available only for column tables.

Sizing

  • Global
select round(sum(USED_FIXED_PART_SIZE + USED_VARIABLE_PART_SIZE)/1024/1024) as "Row Tables MB Used" from M_RS_TABLES
  • For a schema
select SCHEMA_NAME, TABLE_NAME, round((USED_FIXED_PART_SIZE + USED_VARIABLE_PART_SIZE)/1024/1024, 2) as "MB Used" from M_RS_TABLES where SCHEMA_NAME = 'SYS' order by "MB Used" desc, TABLE_NAME

Data Dictionary

RS for ROW Store !

  • Size on memory: table size from SYS.M_TABLES WHERE IS_COLUMN_TABLE = 'FALSE'
  • Size on disk: DISK_SIZE from M_TABLE_PERSISTENCE_STATISTICS
  • M_RS_TABLES: Information on row tables: detailed table sizes and record count

Powered by ComboStrap