TABLENAME |
✔ |
Table name |
MSSTABLE |
CHAR |
128 |
|
TOTALROWS |
|
Number of rows |
MSSNUMROWS |
DEC |
15 |
|
DATASIZE |
|
Data size in KB |
MSSDATASIZE |
DEC |
15 |
|
RESERVED |
|
Reserved size in KB |
MSSRESSIZE |
DEC |
15 |
|
INDEXSIZE |
|
Index size in KB |
MSSINDEXSIZE |
DEC |
15 |
|
ROWMODCTR |
|
Row modification counter |
MSSROWMODCTR |
INT4 |
10 |
|
STATSSCHVER |
|
Statistics schema version |
MSSSTATSSCHVER |
INT4 |
10 |
|
INDEXDEPTH |
|
Depth |
MSSINDDEPTH |
INT4 |
10 |
|
NUMINDEXES |
|
Number of indexes of a table |
MSSNUMINDS |
INT4 |
10 |
|
NUMSTATS |
|
Number of statistics of a table |
MSSNUMSTATS |
INT4 |
10 |
|
STATSDATE |
|
Last update statistics |
MSSSTATSDATE |
CHAR |
20 |
|
TABLEOPTIONS |
|
Table options on locking and memory |
MSSTABOPTS |
CHAR |
10 |
|
BUFFSTATUS |
|
SAP table buffering status on application server. |
MSSTABBUFF |
CHAR |
4 |
|
FILEGROUP |
|
Filegroup name |
MSSFG |
CHAR |
128 |
|
SCANDENSITY |
|
Scan density |
MSSSCANDENSITY |
DEC |
5 |
|
LOGICALFRAG |
|
Logical scan fragmentation |
MSSLOGSCANFRAG |
DEC |
5 |
|
NUMPAGES |
|
Number of pages in index level |
MSSILPAGES |
DEC |
16 |
|
BESTCOUNT |
|
Ideal number of extent changes |
MSSBESTCOUNT |
DEC |
16 |
|
ACTUALCOUNT |
|
Actual number of extent changes |
MSSACTCOUNT |
DEC |
16 |
|
EXTENTSWITCHES |
|
Number of extent switches |
MSSEXTSWITCHES |
DEC |
16 |
|
LASTTABLE |
|
|
|
CHAR |
1 |
|
LASTRUN |
|
|
|
CHAR |
8 |
|
LASTDURATION |
|
Execution duration of an operation in seconds. |
MSSDURATE |
INT4 |
10 |
|