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