SAP ABAP Table SYB_COLSTATS (SYB: Column statistics (density and histogram))

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-SYB (Application Component) Sybase ASE Database Platform
     ⤷ SMSYB (Package) SYBASE Database Monitor

Basic Data

Table Category	INTTAB	Structure
Structure	SYB_COLSTATS	Table Relationship Diagram
Short Description	SYB: Column statistics (density and 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	COLNAME	☐	SYBOBJNAME	SYBOBJNAME	CHAR	128	0	SYB: Object Name (Index, Table, Partition, ...)
2	LASTSTATSUPDATE	☐			STRG	0	0
3	CELLDENSITY	☐			STRG	0	0
4	TOTALDENSITY	☐			STRG	0	0
5	RANGESEL	☐			STRG	0	0
6	INBETSEL	☐			STRG	0	0
7	RANGEVAL	☐			STRG	0	0
8	TOTALVAL	☐			STRG	0	0
9	AVGCOLWIDTH	☐			STRG	0	0
10	REQUESTEDSTEPCNT	☐			INT4	10	0
11	ACTUALSTEPCNT	☐			INT4	10	0
12	SAMPLINGPCT	☐			INT1	3	0
13	HISTOGRAM	☐	SYB_COLHISTOGRAM_TAB		TTYP	0	0
14	IS_COLGROUP	☐			CHAR	1	0

History

Last changed by/on	SAP	20110908
SAP Release Created in	731