/SDF/CSSIZING - Sizing estimation details for HDB Row Store
Sizing estimation details for HDB Row Store information is stored in SAP table /SDF/CSSIZING.
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/CSSIZING
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 | |
| PART_ID | Partition ID | X | /SDF/PARTID | INT4 | 4 | |
| KEYFLAG | Identifies a primary key field | /SDF/PKFIELD | CHAR | 2 | ||
| HAS_INDEX | Identifies a secondary key field | /SDF/SKFIELD | CHAR | 2 | ||
| NOPK_TYPE | Identify a table with no primary key | /SDF/NKFIELD | CHAR | 2 | ||
| MS_TOTAL | Total memory size in bytes | /SDF/MS | DEC | 11 | ||
| MS_MAIN | Main memory size in bytes | /SDF/MAINS | DEC | 11 | ||
| EST_MS_MAIN | Estimated memory size | /SDF/ESTMS | DEC | 11 | ||
| RECORD_COUNT | Number of records in the table | /SDF/RECCOUNT | DEC | 11 | ||
| DISTINCT_COUNT | Disctinct count | /SDF/DISTCOUNT | DEC | 11 | ||
| LOADED | Load status | /SDF/LOADED | CHAR | 10 | ||
| INDEX_LOADED | Index load status | /SDF/KEYLOADED | CHAR | 32 | ||
| COMPRESSION_TYPE | Compression type | /SDF/COPMTYPE | CHAR | 32 | ||
| MS_DICT | Dictionnary size in bytes | /SDF/DICTMS | DEC | 11 | ||
| EST_MS_DICT | Estimated dictionnary size in bytes | /SDF/ESTDICTMS | DEC | 11 | ||
| MS_INDEX | Index memory size in bytes | /SDF/INDEXMS | DEC | 11 | ||
| EST_MS_INDEX | Estimated index memory size in bytes | /SDF/ESTINDEXMS | DEC | 11 | ||
| MS_DATA | Data size in bytes | /SDF/DATAMS | DEC | 11 | ||
| EST_MS_DATA | Estimated data memory size in bytes | /SDF/ESTDATAMS | DEC | 11 | ||
| MS_MISC | Miscelaneous size in bytes | /SDF/MISCMS | DEC | 11 | ||
| EST_MS_MISC | Estimated miscelaneous size in bytes | /SDF/ESTMISCMS | DEC | 11 | ||
| MS_HL | Hybrid LOB size in bytes | /SDF/HL | DEC | 11 | ||
| EST_MS_HL | Estimated Hybrid LOB size in bytes | /SDF/ESTHL | 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 |