SAP ABAP Table MSSINDINFOCOLL (Collection of index information)

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	MSSINDINFOCOLL	Table Relationship Diagram
Short Description	Collection of index information

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

History

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