Skip to end of metadata
Go to start of metadata


This script displays the sizes of indexes in the current HANA system, this includes row and column store indexes.

Input Parameters


Output Parameters

SCHEMA_NAME:   Schema name
TABLE_NAME:    Table name
S:             Store ('C' for column store, 'R' for row store)
INDEX_NAME:    Index name (_SYS_TREE_CS* are names for primary key indexes in column store)
P:             Primary key ('X' if index supports primary key constraint in column store or uniqueness in row store)
MEM_SIZE_GB:   Current size of index in memory (GB)

  • No labels