Data Element list used by SAP ABAP Table MSSIDXRECOMMEND (Index recommendations from sap_index_recommend)
SAP ABAP Table
MSSIDXRECOMMEND (Index recommendations from sap_index_recommend) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
| 1 | MSSAVGTOTSYS | Average cost of syst queries that could be reduced by an ind | ||
| 2 | MSSAVGUCOST | Avg. cost of user queries that could be reduced by an index | ||
| 3 | MSSAVGUIMPACT | Average percentage benefit for user queries | ||
| 4 | MSSAVSYSIMP | Average percentage benefit for system queries | ||
| 5 | MSSDB | Database name | ||
| 6 | MSSEQCOLS | list of columns that contribute to equality predicates | ||
| 7 | MSSIDXLOAD | Total anticipated cumulative improvement | ||
| 8 | MSSINCCOLS | Columns needed as covering columns | ||
| 9 | MSSLSTSYSSCAN | Index usage: Time of last system scan | ||
| 10 | MSSLSTSYSSEEK | Index usage: Time of last system seek | ||
| 11 | MSSLSTUSCAN | Index usage: Last user scan (sql datetime) | ||
| 12 | MSSLSTUSEEK | Index usage: Last user seek (sql datetime) | ||
| 13 | MSSNECOLS | list of columns that contribute to inequality predicates | ||
| 14 | MSSSCHEMA | Schema name | ||
| 15 | MSSTABLE | Table name | ||
| 16 | MSSUQCOMPILES | Number of compilations and recompilations | ||
| 17 | MSSUTOTOPS | Number of seeks and scans by user queries. | ||
| 18 | MSSYSTOTOPS | Number of seeks and scans by system queries. |