Data Element list used by SAP ABAP Table MSQSHCONTG (Displays fragmentation info for data and indexes of a table)
SAP ABAP Table
MSQSHCONTG (Displays fragmentation info for data and indexes of a table) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
| 1 | MSQACTEXCT | Number of extents scanned ( = extent switches +1). | ||
| 2 | MSQAVFRBYT | Average number of free bytes on the pages scanned. | ||
| 3 | MSQAVPGDEN | Average page density as percentage (the higher, the better). | ||
| 4 | MSQAVRWSZ | Average record size (byte). | ||
| 5 | MSQBESTEXT | Ideal no. of extent changes if all are contiguously linked. | ||
| 6 | MSQEXTFRAG | Extent fragmentation in scanning the leaf pages of an index | ||
| 7 | MSQEXTSWIT | No. of extent switches by traversing the index level. | ||
| 8 | MSQIDXEXTS | No. of extents in that index level or entire heap. | ||
| 9 | MSQIDXLEVL | Level within the index tree - 0 is the leaf (or data) level. | ||
| 10 | MSQIDXPAGS | No. of pages in the index level. | ||
| 11 | MSQIDXROWS | No. of rows in that level of the index. | ||
| 12 | MSQIXFORRD | No. of forwarded records in that index level or entire heap. | ||
| 13 | MSQLOGFRAG | Logical fragmentation in leaf-pages of an index. | ||
| 14 | MSQOBJID | SQL Server object or index ID. | ||
| 15 | MSQOBJID | SQL Server object or index ID. | ||
| 16 | MSQOBTNAME | Table or index name. | ||
| 17 | MSQOBTNAME | Table or index name. | ||
| 18 | MSQSCANDEN | Scan density of extents (100% is the best value). | ||
| 19 | MSSMAXRCSZ | Maximum record size in that level of the index. | ||
| 20 | MSSMINRCSZ | Minimum record size in that level of the index. |