SAP ABAP Data Element INFFRAGTYP (Fragmentation category)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DWB-DIC-AC (Application Component) Activation Program, Conversion Program, DB Utility, MC, SPDD
     ⤷ SDIC (Package) ABAP Dictionary

Basic Data

Data Element	INFFRAGTYP
Short Description	Fragmentation category

Data Type

Category of Dictionary Type	D	Domain
Type of Object Referenced		No Information
Domain / Name of Reference Type	INFFRAGTYP
Data Type	CHAR	Character String
Length	12
Decimal Places	0
Output Length	12
Value Table

Further Characteristics

Search Help: Name
Search Help: Parameters
Parameter ID
Default Component name
Change document	☐
No Input History	☐
Basic direction is set to LTR	☐
No BIDI Filtering	☐

Field Label

	Length	Field Label
Short	10	Fragm.Cat.
Medium	18	Fragmentation cat.
Long	20	Fragmentation cat.
Heading	18	Fragmentation cat.

Documentation

Definition

Definition of the fragmentation type for a table or index.

The possible fragmentation types are round robin, expression-based and hash fragmentation. Hash fragmentation is only possible on Informix databases with the decision support option.

With round robin fragmentation, the data is evenly distsributed on the relevant dbspaces. With expression-based fragmentation, an expression is defined for each fragment and the data is distributed in the fragments according to this expression. Hash fragmentation distributes the rows based on a list of table fields using a database-internal hash function.

Note

Indexes may not be round robin fragmented.

History

Last changed by/on	SAP	20010130
SAP Release Created in