SAP ABAP Data Element AM_OPTIO (Sample Size 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
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_OPTIO |
| Short Description | Sample Size for Collection of Statistics |
Data Type
| Category of Dictionary Type | D | Domain |
| Type of Object Referenced | No Information | |
| Domain / Name of Reference Type | CHAR5 | |
| Data Type | CHAR | Character String |
| Length | 5 | |
| Decimal Places | 0 | |
| Output Length | 5 | |
| 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 | Sample |
| Medium | 15 | Sample |
| Long | 20 | Sample Size |
| Heading | 6 | Sample |
Documentation
Definition
ORACLE:
For the analysis methods E, EH, EI and EX, the following sample sizes are permissible:
P<p>: <p> Prozent of the table entries are used to update the statistics.
R<r>: <r> thousand entries of the table are used to update the statistics.
DB2/390:
Percentage of the data records in a table, used for statistics for non- indexed columns (option SAMPLE in DB2 utility RUNSTATS).
This field is not used for INFORMIX and ADABAS.
History
| Last changed by/on | SAP | 20020827 |
| SAP Release Created in |
