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. |