SAP ABAP Table MSSDBSTATT (Table statistics for MS SQL Server)
Hierarchy
☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-MSS-CCM (Application Component) CCMS / Database Monitors for SQL Server
     ⤷ STUS (Package) SQL Server Monitor
Basic Data
Table Category TRANSP    Transparent table 
Transparent table MSSDBSTATT   Table Relationship Diagram
Short Description Table statistics for MS SQL Server    
Delivery and Maintenance
Pool/cluster      
Delivery Class L   Table for storing temporary data, delivered empty 
Data Browser/Table View Maintenance     Display/Maintenance Allowed with Restrictions 
Components
     
Field Key Data Element Domain Data
Type		 Length Decimal
Places		 Short Description Check
table
1 TABLENAME MSSTABLE MSSSYSNAME CHAR 128   0   Table name  
2 TOTALROWS MSSNUMROWS   DEC 15   0   Number of rows  
3 DATASIZE MSSDATASIZE   DEC 15   0   Data size in KB  
4 RESERVED MSSRESSIZE   DEC 15   0   Reserved size in KB  
5 INDEXSIZE MSSINDEXSIZE   DEC 15   0   Index size in KB  
6 ROWMODCTR MSSROWMODCTR   INT4 10   0   Row modification counter  
7 STATSSCHVER MSSSTATSSCHVER   INT4 10   0   Statistics schema version  
8 INDEXDEPTH MSSINDDEPTH   INT4 10   0   Depth  
9 NUMINDEXES MSSNUMINDS   INT4 10   0   Number of indexes of a table  
10 NUMSTATS MSSNUMSTATS   INT4 10   0   Number of statistics of a table  
11 STATSDATE MSSSTATSDATE   CHAR 20   0   Last update statistics  
12 TABLEOPTIONS MSSTABOPTS CHAR10 CHAR 10   0   Table options on locking and memory  
13 BUFFSTATUS MSSTABBUFF CHAR4 CHAR 4   0   SAP table buffering status on application server.  
14 FILEGROUP MSSFG MSSSYSNAME CHAR 128   0   Filegroup name  
15 SCANDENSITY MSSSCANDENSITY   DEC 5   2   Scan density  
16 LOGICALFRAG MSSLOGSCANFRAG   DEC 5   2   Logical scan fragmentation  
17 NUMPAGES MSSILPAGES   DEC 16   0   Number of pages in index level  
18 BESTCOUNT MSSBESTCOUNT   DEC 16   0   Ideal number of extent changes  
19 ACTUALCOUNT MSSACTCOUNT   DEC 16   0   Actual number of extent changes  
20 EXTENTSWITCHES MSSEXTSWITCHES   DEC 16   0   Number of extent switches  
21 LASTTABLE     CHAR 1   0    
22 LASTRUN     CHAR 8   0    
23 LASTDURATION MSSDURATE INT4 INT4 10   0   Execution duration of an operation in seconds.  
History
Last changed by/on SAP  20110908 
SAP Release Created in 620