Skip to end of metadata
Go to start of metadata

HANA_Tables_ColumnStore_TableSize_History

Displays historic table sizes in the column store including main and delta sizes, number of rows and number of merges.

Input Parameters

BEGIN_TIME
END_TIME
HOST
SCHEMA_NAME
TABLE_NAME          
OBJECT_LEVEL
TIME_AGGREGATE_BY

Output Parameters

SAMPLE_TIME:   Timestamp
HOST:          Host name
SCHEMA_NAME:   Schema name
TABLE_NAME:    Table name
RECORDS_TOTAL: Total number of rows
RECORDS_MAIN:  Number of rows in main storage
RECORDS_DELTA: Number of rows in delta storage
TOTAL_GB:      Total table size (GB)
MAIN_GB:       Total table size in main (GB)
DELTA_GB:      Total table size in delta (GB)
DELTA_PCT:     Percentage of table size in delta
MERGES:        Number of delta merges on table

  • No labels