SAP ABAP Table MSQIDXDETS (MS SQL server - Index details & statistics)
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
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 | MSQIDXDETS |
Table Relationship Diagram 
|
| Short Description | MS SQL server - Index details & statistics |
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 |  IDXNAME |
MSQTABNAME | CHAR256 | CHAR | 256 | 0 | MS SQL server table or index name | ||
| 2 | IDXDESC |
MSQIDXDESC | MSQCHR210 | CHAR | 210 | 0 | SQL Server index description | ||
| 3 | IDXKEYS |
MSQINDKEYS | CHAR2078 | CHAR | 2078 | 0 | The table columns in the index key. | ||
| 4 | IDXHGT |
MSQIDXHGT | INT2 | INT2 | 5 | 0 | Number of index levels excluding data pages (index height). | ||
| 5 | ROWMINLEN |
MSQMINLEN | INT2 | INT2 | 5 | 0 | MS SQL server minimum size of the row. | ||
| 6 | ROWMAXLEN |
MSQMAXLEN | INT2 | INT2 | 5 | 0 | MS SQL server - maximum size of a row | ||
| 7 | ROWMODCTR |
MSQMODROWS | DEC | 16 | 0 | MS SQL server - modified rows in the table since upd stats | |||
| 8 | AUTOUPDFLG |
MSQAUTOUPD | CHAR3 | CHAR | 3 | 0 | SQL Server flag for auto update statistics for table index. | ||
| 9 | UPDDATE |
MSQLSTUPST | CHAR30 | CHAR | 30 | 0 | Last time the index statistics was updated. |
History
| Last changed by/on | SAP | 20130604 |
| SAP Release Created in |
