Skip to end of metadata
Go to start of metadata

HANA_Indexes_LargestIndexes

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

Input Parameters

SCHEMA_NAME
TABLE_NAME          
RESULT_ROWS

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