SAP ABAP Table SYB_SYSTABSTATS (SYB: <dbname>..systabstats)

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_SYSTABSTATS	Table Relationship Diagram
Short Description	SYB: <dbname>..systabstats

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	INDID	☐	SYBOBJID		INT4	10	0	SYB: Object ID (Index, Table, DB, Partition, ...)
2	INDEXHEIGHT	☐			INT4	10	0
3	CONOPT_THLD	☐			INT4	10	0
4	PLLDEGREE	☐			INT2	5	0
5	ID	☐	SYBOBJID		INT4	10	0	SYB: Object ID (Index, Table, DB, Partition, ...)
6	LEAFCNT	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
7	PAGECNT	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
8	OAMAPGCNT	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
9	EXTENT0PGCNT	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
10	PLLJOINDEGREE	☐			INT2	5	0
11	RSLASTOAM	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
12	RSLASTPAGE	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
13	FRLASTOAM	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
14	FRLASTPAGE	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
15	EMPTYPGCNT	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
16	PARTITIONID	☐	SYBOBJID		INT4	10	0	SYB: Object ID (Index, Table, DB, Partition, ...)
17	WARMCACHEPGCNT	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
18	UNUSEDPGCNT	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
19	OAMPAGECNT	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
20	ROWCNT	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
21	FORWROWCNT	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
22	DELROWCNT	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
23	DPAGECRCNT	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
24	IPAGECRCNT	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
25	DROWCRCNT	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
26	DATAROWSIZE	☐			INT4	10	0
27	LEAFROWSIZE	☐			INT4	10	0
28	STATMODDATE	☐	DB6TSTAMP		CHAR	14	0	DB6: Timestamp (Format: YYYYMMDDHHMMSS)
29	PIOCLMDATA	☐			INT4	10	0
30	PIOCLMINDEX	☐			INT4	10	0
31	PIOCSMDATA	☐			INT4	10	0
32	PIOCSMINDEX	☐			INT4	10	0
33	PAGECLRATIO	☐			DEC	6	2
34	IPAGECLRATIO	☐			DEC	6	2
35	ROWCLRATIO	☐			DEC	6	2
36	LARGEIOEFF	☐			DEC	6	2
37	DATACHANGE	☐			DEC	14	2
38	SPACE_UTL_PCT	☐			DEC	6	2
39	SPACE_UTL_KB	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
40	TAB_USED_KB	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
41	TAB_RESERVED_KB	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer

History

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