Skip to end of metadata
Go to start of metadata

HANA_Tables_ColumnStore_Records

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

Input Parameters

HOST
PORT
SCHEMA_NAME
TABLE_NAME          
OBJECT_LEVEL
MIN_TOTAL_RECORDS
MIN_DELTA_RECORDS
MIN_DELTA_PCT
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 storage
DELTA_PCT:       Percentage of rows in delta (delta / (main + delta))
LAST_MERGE_TIME: Time of last successful merge operation

  • No labels