Data Element list used by SAP ABAP Table MSSDBSTATT (Table statistics for MS SQL Server)
SAP ABAP Table
MSSDBSTATT (Table statistics for MS SQL Server) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
| 1 | MSSACTCOUNT | Actual number of extent changes | ||
| 2 | MSSBESTCOUNT | Ideal number of extent changes | ||
| 3 | MSSDATASIZE | Data size in KB | ||
| 4 | MSSDURATE | Execution duration of an operation in seconds. | ||
| 5 | MSSEXTSWITCHES | Number of extent switches | ||
| 6 | MSSFG | Filegroup name | ||
| 7 | MSSILPAGES | Number of pages in index level | ||
| 8 | MSSINDDEPTH | Depth | ||
| 9 | MSSINDEXSIZE | Index size in KB | ||
| 10 | MSSLOGSCANFRAG | Logical scan fragmentation | ||
| 11 | MSSNUMINDS | Number of indexes of a table | ||
| 12 | MSSNUMROWS | Number of rows | ||
| 13 | MSSNUMSTATS | Number of statistics of a table | ||
| 14 | MSSRESSIZE | Reserved size in KB | ||
| 15 | MSSROWMODCTR | Row modification counter | ||
| 16 | MSSSCANDENSITY | Scan density | ||
| 17 | MSSSTATSDATE | Last update statistics | ||
| 18 | MSSSTATSSCHVER | Statistics schema version | ||
| 19 | MSSTABBUFF | SAP table buffering status on application server. | ||
| 20 | MSSTABLE | Table name | ||
| 21 | MSSTABOPTS | Table options on locking and memory |