SAP ABAP Table MSSHISTOGRAM (Output from running dbcc show_statistics with histogram)
Hierarchy
☛
SAP_BASIS (Software Component) SAP Basis Component
⤷
BC-DB-MSS (Application Component) Microsoft SQL Server
⤷
STUN_MSS (Package) Package for new SQL Server monitoring objects
SAP_BASIS (Software Component) SAP Basis Component⤷
BC-DB-MSS (Application Component) Microsoft SQL Server⤷
STUN_MSS (Package) Package for new SQL Server monitoring objects
Basic Data
| Table Category | INTTAB | Structure |
| Structure | MSSHISTOGRAM |
Table Relationship Diagram 
|
| Short Description | Output from running dbcc show_statistics with histogram |
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 |  R_HI_KEY |
MSSDBCCKEY | CHAR | 156 | 0 | Key value output from dbcc show_statistics | |||
| 2 | R_ROWS |
MSSRNGROWS | MSSROWCNT | DEC | 16 | 0 | Est. number of rows from the table that fall within range | ||
| 3 | EQ_ROWS |
MSSEQROWS | MSSROWCNT | DEC | 16 | 0 | Estimated number of rows that are equal to the upper bound | ||
| 4 | DIST_RNG_ROWS |
MSSDISTRNGROWS | MSSROWCNT | DEC | 16 | 0 | Estimated number of distinct values within a histogram step | ||
| 5 | AVG_RNG_ROWS |
MSSAVGRNGROWS | MSSROWCNT | DEC | 16 | 0 | Average number of duplicate values within a histogram step | ||
| 6 | EQ_ROWS_PCT |
MSSEQROWSPCT | DEC | 4 | 2 | Percentage of all rows |
History
| Last changed by/on | SAP | 20110908 |
| SAP Release Created in | 710 |
