Skip to end of metadata
Go to start of metadata

HANA_Tables_ColumnStore_DeltaStorage

 

Displays record and size information for delta and main storage including the last merge time.

More information on memory management and the delta merge operation is available in the "Managing Tables" section of the SAP HANA Administration Guide:

http://help.sap.com/saphelp_hanaplatform/helpdata/en/bd/6e6be8bb5710149e34e14608e07b76/content.htm?frameset=/en/68/554490aee94885ba31611489a04992/frameset.htm&current_toc=/en/00/0ca1e3486640ef8b884cdf1a050fbb/plain.htm&node_id=149&show_children=false

Input Parameters

HOST

PORT

SCHEMA_NAME

TABLE_NAME

OBJET_LEVEL

MIN_TOTAL_RECORDS

MIN_DELTA_RECORDS

MIN_DELTA_REC_PCT

MIN_DELTA_MEM_PCT

MIN_DELTA_SIZE_MB

AGGREGATE_BY

ORDER_BY

RESULT_ROWS

Output Parameters

HOST:            Host

PORT:            Port

SCHEMA_NAME:     Schema name

TABLE_NAME:      Table name

RECORDS:         Number of rows

RECORDS_MAIN:    Raw number of rows in main store

RECORDS_DELTA:   Raw number of rows in delta store

DELTA_PCT:       Percentage of rows in delta (delta / (main + delta))

LAST_MERGE_TIME: Time of last successful merge operation

  • No labels