SAP ABAP Table MSSIDXRECOMMEND (Index recommendations from sap_index_recommend)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-MSS (Application Component) Microsoft SQL Server
     ⤷ STUN_MSS (Package) Package for new SQL Server monitoring objects

Basic Data

Table Category	INTTAB	Structure
Structure	MSSIDXRECOMMEND	Table Relationship Diagram
Short Description	Index recommendations from sap_index_recommend

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	DBNAME	☐	MSSDB	MSSSYSNAME	CHAR	128	0	Database name
2	SCHEMANAME	☐	MSSSCHEMA	MSSSYSNAME	CHAR	128	0	Schema name
3	TABNAME	☐	MSSTABLE	MSSSYSNAME	CHAR	128	0	Table name
4	DBLOAD	☐	MSSIDXLOAD		DEC	15	0	Total anticipated cumulative improvement
5	AVG_USER_COST	☐	MSSAVGUCOST		DEC	15	0	Avg. cost of user queries that could be reduced by an index
6	AVG_USER_IMPACT	☐	MSSAVGUIMPACT		DEC	15	2	Average percentage benefit for user queries
7	USER_TOTAL_OPS	☐	MSSUTOTOPS		DEC	15	0	Number of seeks and scans by user queries.
8	EQUALITY_COLUMNS	☐	MSSEQCOLS	MSSIDXRECCOLS	CHAR	256	0	list of columns that contribute to equality predicates
9	INEQUALITY_COLUMNS	☐	MSSNECOLS	MSSIDXRECCOLS	CHAR	256	0	list of columns that contribute to inequality predicates
10	INCLUDED_COLUMNS	☐	MSSINCCOLS	MSSIDXRECCOLS	CHAR	256	0	Columns needed as covering columns
11	LAST_USER_SEEK	☐	MSSLSTUSEEK		CHAR	24	0	Index usage: Last user seek (sql datetime)
12	LAST_USER_SCAN	☐	MSSLSTUSCAN		CHAR	24	0	Index usage: Last user scan (sql datetime)
13	UNIQUE_COMPILES	☐	MSSUQCOMPILES		DEC	15	0	Number of compilations and recompilations
14	AVG_TOTAL_SYSTEM_COST	☐	MSSAVGTOTSYS		DEC	15	0	Average cost of syst queries that could be reduced by an ind
15	AVG_SYSTEM_IMPACT	☐	MSSAVSYSIMP		DEC	15	2	Average percentage benefit for system queries
16	SYSTEM_TOTAL_OPS	☐	MSSYSTOTOPS		DEC	15	0	Number of seeks and scans by system queries.
17	LAST_SYSTEM_SEEK	☐	MSSLSTSYSSEEK		CHAR	24	0	Index usage: Time of last system seek
18	LAST_SYSTEM_SCAN	☐	MSSLSTSYSSCAN		CHAR	24	0	Index usage: Time of last system scan

History

Last changed by/on	SAP	20110908
SAP Release Created in	710