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. |