Sap Hana - Row tables

Sap Hana Architecture

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





Discover More
Sap Hana Architecture
Attribute views

are used to model an entity based on the relationships between attribute data contained in multiple source tables. You can add to the attribute view: more columns and also hierarchies Analytic...
Sap Hana Used Memory
SAP Hana - Used memory

The total amount of memory used by SAP HANA is referred to as used memory. At any given point, only parts of the memory pool are really in use. SAP refers to the total amount of memory actually in use...
Sap Hana Memory
Sap Hana - Shared Memory ( OS )

An early SAP HANA design decision was to use “shared memory” for row-store tables. As a result, when you use large row-store tables, the shared-memory footprint of SAP HANA can become very large....
Sap Hana Architecture
Sap Hana - Table

UNLOAD saphelp_hanaplatform/helpdata/en/21/0197377519101481cfb213f0b84848/content.htmTables saphelp_hanaplatform/helpdata/en/20/c7689a75191014ad52c1beb40ce2d2/content.htmM_TABLES - Information on...
Hana Column Store Write Read Operations
Sap Hana - Table Column - Column Store

Table column. Data Structure Access Pattern Compression Main Storage Optimized for read access Advanced Delta Storage Optimized for write access Basic Read operations are performed on...



Share this page:
Follow us:
Task Runner