SAP ABAP Table /SDF/MSSDBSTATS (SQL Server: Statistics on database tables ( MSDDBSTATS ))
Hierarchy
☛
ST-PI (Software Component) SAP Solution Tools Plug-In
⤷ SV-SMG-SDD (Application Component) Service Data Download
⤷ /SDF/STPI_DDIC (Package) DDIC for /SDF/STPI Development
⤷ SV-SMG-SDD (Application Component) Service Data Download
⤷ /SDF/STPI_DDIC (Package) DDIC for /SDF/STPI Development
Basic Data
Table Category | INTTAB | Structure |
Structure | /SDF/MSSDBSTATS | Table Relationship Diagram |
Short Description | SQL Server: Statistics on database tables ( MSDDBSTATS ) |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
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 | CHAR | 128 | 0 | |||||
2 | TOTALROWS | DEC | 15 | 0 | |||||
3 | DATASIZE | DEC | 15 | 0 | |||||
4 | RESERVED | DEC | 15 | 0 | |||||
5 | INDEXSIZE | DEC | 15 | 0 | |||||
6 | ROWMODCTR | INT4 | 10 | 0 | |||||
7 | STATSSCHVER | INT4 | 10 | 0 | |||||
8 | INDEXDEPTH | INT4 | 10 | 0 | |||||
9 | NUMINDEXES | INT4 | 10 | 0 | |||||
10 | NUMSTATS | INT4 | 10 | 0 | |||||
11 | STATSDATE | CHAR | 20 | 0 | |||||
12 | TABLEOPTIONS | CHAR | 10 | 0 | |||||
13 | BUFFSTATUS | CHAR | 4 | 0 | |||||
14 | FILEGROUP | CHAR | 128 | 0 | |||||
15 | SCANDENSITY | /SDF/MSSRATE | /SDF/MSSRATE | DEC | 5 | 2 | SQL Server: Fragmentation rate (DEC 5,2) | ||
16 | LOGICALFRAG | /SDF/MSSRATE | /SDF/MSSRATE | DEC | 5 | 2 | SQL Server: Fragmentation rate (DEC 5,2) | ||
17 | NUMPAGES | INT4 | 10 | 0 | |||||
18 | BESTCOUNT | INT4 | 10 | 0 | |||||
19 | ACTUALCOUNT | INT4 | 10 | 0 | |||||
20 | AVGPGPEREX | FLTP | 16 | 16 | |||||
21 | EXTSCANFRG | INT4 | 10 | 0 | |||||
22 | AVGPGDSTF | INT4 | 10 | 0 | |||||
23 | MISC | CHAR | 256 | 0 |
History
Last changed by/on | SAP | 20140922 |
SAP Release Created in |