SHDB_INDEX_RES - Results of Index analysis SHDB_INDEX_ANALYZE
Results of Index analysis SHDB_INDEX_ANALYZE information is stored in SAP table SHDB_INDEX_RES.
It is part of development package SHDB in software component BC-DB-HDB-POR. This development package consists of objects that can be grouped under "Basis Package for HDB".
It is part of development package SHDB in software component BC-DB-HDB-POR. This development package consists of objects that can be grouped under "Basis Package for HDB".
Fields for table SHDB_INDEX_RES
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| TABNAME | Table Name | X | TABNAME | CHAR | 60 | * |
| FIELDNAME | Field Name | X | FIELDNAME | CHAR | 60 | * |
| DEVCLASS | Package | DEVCLASS | CHAR | 60 | * | |
| DLVUNIT | Software Component | DLVUNIT | CHAR | 60 | * | |
| NAMESPACE | Namespace | NAMESPACE | CHAR | 20 | * | |
| SAPFLAG | Belongs to SAP standard delivery | SAPSTANDRD | CHAR | 2 | ||
| RECORD_COUNT | number of records in table | DEC | 11 | |||
| DISTINCT_COUNT | Number of distinct values in column | DEC | 11 | |||
| INDEX_CREA_INP | Input for the index creation (SHDB_INDEX_CREATE) | CHAR | 160 | |||
| DATE_RESULT | date of the analysis run (SHDB_INDEX_ANALYZE) | DATS | 16 |