SAP ABAP Table MSSINDMISCINFO (Index name + misc. 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	MSSINDMISCINFO	Table Relationship Diagram
Short Description	Index name + misc. 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	.INCLUDE	☐				0	0	Misc. index information
3	DEPTH	☐	MSSINDDEPTH		INT4	10	0	Depth
4	ROWMINLEN	☐	MSSROWMINLEN		INT2	5	0	Minimum size of a row
5	ROWMAXLEN	☐	MSSROWMAXLEN		INT2	5	0	Maximum size of a row
6	ROWMODCTR	☐	MSSROWMODCTR		INT4	10	0	Row modification counter
7	AUTOSTATS	☐	MSSAUTOSTATS		CHAR	3	0	Auto update statistics setting
8	STATSDATE	☐	MSSSTATSDATE		CHAR	20	0	Last update statistics
9	DATASZ	☐	MSSINDEXSZ		DEC	15	0	Index size in KB
10	RESERVEDSZ	☐	MSSINDEXRSV		DEC	15	0	Index reserved size in KB
11	USEDSZ	☐	MSSINDEXUSED		DEC	15	0	Index used size in KB
12	COMPRESSION	☐	MSSCOMPTYPE		CHAR	20	0	Compression type, ROW, PAGE, COLUMNSTORE or NONE

History

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