SAP Table MSSSHOWCONOUT
Output of dbcc showcontig
MSSSHOWCONOUT (Output of dbcc showcontig) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link MSSSHOWCONOUT to other SAP tables.
MSSSHOWCONOUT table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||
|---|---|---|---|---|---|---|---|---|
| TABLENAME | Table name | MSSTABLE | CHAR | 128 | 0 | |||
| OBJECTID | Object id | MSSOBJID | INT4 | 10 | 0 | |||
| INDEXNAME | Index name | MSSINDEX | CHAR | 128 | 0 | |||
| INDEXID | Index id | MSSINDEXID | INT2 | 5 | 0 | |||
| LEVEL | Index level | MSSINDLEVEL | INT4 | 10 | 0 | |||
| PAGES | Number of pages in index level | MSSILPAGES | DEC | 16 | 0 | |||
| ROWS | Number of data or index rows in index level | MSSILROWS | DEC | 16 | 0 | |||
| ROWMINLEN | Minimum row size in index level | MSSILROWMINLEN | INT4 | 10 | 0 | |||
| ROWMAXLEN | Maximum row size in index level | MSSILROWMAXLEN | INT4 | 10 | 0 | |||
| ROWAVGLEN | Average row size in index level | MSSILROWAVGLEN | DEC | 12 | 2 | |||
| FORWARDEDROWS | Number of forwarded rows in index level | MSSILFWDROWS | DEC | 16 | 0 | |||
| EXTENTS | Number of extents in index level | MSSILEXTENTS | DEC | 16 | 0 | |||
| EXTENTSWITCHES | Number of extent switches | MSSEXTSWITCHES | DEC | 16 | 0 | |||
| AVGFREEBYTES | Average number of bytes free per page | MSSAVGFREEBYTES | DEC | 6 | 2 | |||
| AVGPAGEDENSITY | Average page density | MSSAVGPGDENSITY | DEC | 5 | 2 | |||
| SCANDENSITY | Scan density | MSSSCANDENSITY | DEC | 5 | 2 | |||
| BESTCOUNT | Ideal number of extent changes | MSSBESTCOUNT | DEC | 16 | 0 | |||
| ACTUALCOUNT | Actual number of extent changes | MSSACTCOUNT | DEC | 16 | 0 | |||
| LOGICALFRAG | Logical scan fragmentation | MSSLOGSCANFRAG | DEC | 5 | 2 | |||
| EXTENTFRAG | Extent scan fragmentation | MSSEXTSCANFRAG | DEC | 5 | 2 | |||
