SAP ABAP Table MSSDISPINDINFOCOLL (Structure only used to display index and statistics details)

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	MSSDISPINDINFOCOLL	Table Relationship Diagram
Short Description	Structure only used to display index and statistics details

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	.INCLUDE	☐				0	0	Collection of index information
2	INDNAME	☐	MSSINDEX	MSSSYSNAME	CHAR	128	0	Index name
3	DESCRIPTION	☐	MSSINDDESC		CHAR	255	0	Index description
4	COLUMNS	☐	MSSINDCOLS		CHAR	2078	0	Index columns
5	.INCLUDE	☐				0	0	Misc. index information
6	DEPTH	☐	MSSINDDEPTH		INT4	10	0	Depth
7	ROWMINLEN	☐	MSSROWMINLEN		INT2	5	0	Minimum size of a row
8	ROWMAXLEN	☐	MSSROWMAXLEN		INT2	5	0	Maximum size of a row
9	ROWMODCTR	☐	MSSROWMODCTR		INT4	10	0	Row modification counter
10	AUTOSTATS	☐	MSSAUTOSTATS		CHAR	3	0	Auto update statistics setting
11	STATSDATE	☐	MSSSTATSDATE		CHAR	20	0	Last update statistics
12	DATASZ	☐	MSSINDEXSZ		DEC	15	0	Index size in KB
13	RESERVEDSZ	☐	MSSINDEXRSV		DEC	15	0	Index reserved size in KB
14	USEDSZ	☐	MSSINDEXUSED		DEC	15	0	Index used size in KB
15	COMPRESSION	☐	MSSCOMPTYPE		CHAR	20	0	Compression type, ROW, PAGE, COLUMNSTORE or NONE
16	FIRSTCOLDENS	☐	MSSFIRSTCOLDENS		CHAR	16	0	Density of first column in an index or statistic

History

Last changed by/on	SAP	20141013
SAP Release Created in	732