SAP ABAP Table SYB_INDSTATS (SYB: Index level statistics)

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_INDSTATS	Table Relationship Diagram
Short Description	SYB: Index level statistics

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	INDEX_NAME	☐	SYBOBJNAME	SYBOBJNAME	CHAR	128	0	SYB: Object Name (Index, Table, Partition, ...)
2	LEAFCNT	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
3	EMPTYLEAFCNT	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
4	CRCNT	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
5	IPAGECRCNT	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
6	DROWCRCNT	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
7	EXTENT0LEAFCNT	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
8	LEAFROWSIZE	☐			INT4	10	0
9	INDEXHEIGHT	☐			INT2	5	0
10	CLUSTERRATIO	☐			DEC	6	2
11	INDCLUSTERRATIO	☐			DEC	6	2
12	DATACLUSTERRATIO	☐			DEC	6	2
13	SPACE_UTL_PCT	☐			DEC	6	2
14	LARGEIOEFF	☐			DEC	6	2

History

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