/SDF/RSSIZING - Sizing estimation details for HDB Row Store
Sizing estimation details for HDB Row Store information is stored in SAP table /SDF/RSSIZING.
It is part of development package /SDF/STPI_6X in software component SV-SMG-SDD. This development package consists of objects that can be grouped under "Release 6.XX dependent Basis Addon SLM".
It is part of development package /SDF/STPI_6X in software component SV-SMG-SDD. This development package consists of objects that can be grouped under "Release 6.XX dependent Basis Addon SLM".
Fields for table /SDF/RSSIZING
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| TABLE_NAME | Table name | X | /SDF/TABLENAME | CHAR | 60 | |
| COLUMN_NAME | Column name | X | /SDF/COLUMNNAME | CHAR | 120 | |
| KEYFLAG | Identifies a primary key field | /SDF/PKFIELD | CHAR | 2 | ||
| HAS_INDEX | Identifies a secondary key field | /SDF/SKFIELD | CHAR | 2 | ||
| RECORD_COUNT | Number of records in the table | /SDF/RECCOUNT | DEC | 11 | ||
| VARIABLE_SIZE | Estimated variable size in bytes | /SDF/ESTVS | DEC | 11 | ||
| FIXED_SIZE | Estiamted fixed size in bytes | /SDF/ESTFS | DEC | 11 | ||
| EST_MS_TOTAL | Estimated memory size | /SDF/ESTMS | DEC | 11 | ||
| TYPEKIND | Category of dictionnary type | /SDF/DATATYPE | CHAR | 2 | ||
| SIZE_BYTE | Average field size in bytes | /SDF/FIELDSIZE | DEC | 9 | ||
| LOB_SIZE_BYTE | Average LOB field size in bytes | /SDF/LOBFIELDSIZE | DEC | 9 | ||
| DLOB_SIZE_BYTE | Average size in bytes of a hybrid lob record | /SDF/HLFIELDSIZE | DEC | 9 | ||
| DLOB_COUNT | Estimated number of hybrid lob records | /SDF/HLCOUNT | DEC | 11 | ||
| MLOB_SIZE_BYTE | Average size in bytes of a in-memory lob record | /SDF/MLOBFIELDSIZE | DEC | 9 | ||
| MLOB_COUNT | Estimated number of in-memory LOB | /SDF/MLOBCOUNT | DEC | 11 |