Hierarchy
⤷ BC-DB-ORA-CCM (Application Component) CCMS / Database Monitors for Oracle
⤷ SDBA (Package) DBA: Database-Independent Code
Basic Data
Data Element | AM_AMETH |
Short Description | Analysis Method for Collecting Statistics |
Data Type
Category of Dictionary Type | D | Domain |
Type of Object Referenced | No Information | |
Domain / Name of Reference Type | AM_AMETH | |
Data Type | CHAR | Character String |
Length | 4 | |
Decimal Places | 0 | |
Output Length | 4 | |
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 | Analysis |
Medium | 15 | Analysis method |
Long | 20 | Analysis method |
Heading | 7 | Anlys |
Documentation
Definition
ORACLE: The method for updating statistics for a database object.
Always specify the analysis method that is to be used for updating the statistics. For existing entries, the method is preset by SAP and is used by BRCONNECT: Only change this method if you are certain that the change is correct.
Possible settings:
E - Estimate statistics (Standard)
EH - Estimate statistics and create historgram
EI - Estimate statistics and evaluate structure of indexes
EX - Estimate statistics and create histogram and evaluate structure of indexes
C - Create exact statistics
CH - Create exact statistics and create histogram
CI - Create exact statistics and evaluate structure of indexes
CX - Create exact statistics and create histogram and evaluate structure of indexes
This field has no relevance for other databases.
History
Last changed by/on | SAP | 20020827 |
SAP Release Created in |