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