SAP ABAP Data Element AM_SIGNI (Significance for Collection of Statistics)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-ORA-CCM (Application Component) CCMS / Database Monitors for Oracle
     ⤷ SDBA (Package) DBA: Database-Independent Code

Basic Data

Data Element	AM_SIGNI
Short Description	Significance for Collection of Statistics

Data Type

Category of Dictionary Type	D	Domain
Type of Object Referenced		No Information
Domain / Name of Reference Type	AM_SIGNI
Data Type	INT1	1-byte integer, integer number <= 255
Length	3
Decimal Places	0
Output Length	3
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	Signific.
Medium	15	Significance
Long	20	Significance
Heading	3	Sig

Documentation

Definition

The significance describes the accuracy of the collection of statistics. You can determine the accuracy of the analysis by selecting numbers (depending on the DB system).

ORACLE
This field is not used. The fields AMETH and OPTIO specify the degree of significance instead.

INFORMIX
Possible values are:

• 1: Update Statistics HIGH for all index columns
• 2: Update Statistics HIGH for leading index columns,
  MEDIUM for all other index columns (default)

ADABAS
This field is not used.

DB2/390
Possible values are:

• 1: Update Statistics with high accuracy
• 2: Update Statistics with medium accuracy
• 3: Update Statistics with minimum accuracy
  The analysis methods differ by what percentage of data records in a table are used to determine statistics. The values can be maintained in Transaction DB2J (under "Runstats" in the "Profile parameter" screen).

History

Last changed by/on	SAP	20020827
SAP Release Created in