SAP ABAP Domain AM_AMETH (Analysis method for tables and indexes under ORACLE 7)
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
| Domain Name | AM_AMETH |
| Short Description | Analysis method for tables and indexes under ORACLE 7 |
Definition
| Data Type | CHAR | Character String |
| No. Characters | 4 | |
| Decimal Places | ||
| Output Length | 4 | |
| Conversion Routine | ||
| Sign | ||
| Lower Case |
Value Range
| # | Lower Limit | Upper Limit | Short Description |
|---|---|---|---|
| 1 | E | Estimate Statistics (Standard) | |
| 2 | EH | Estimate Statistics and Generate Histograms | |
| 3 | EI | Estimate Statistics and Evaluate Structure of Indexes | |
| 4 | EX | Estimate Statistics/Generate Histograms/Evaluate Structure | |
| 5 | C | Create Exact Statistics | |
| 6 | CH | Create Exact Statistics and Generate Histograms | |
| 7 | CI | Create Exact Statistics and Evaluate Structure of Indexes | |
| 8 | CX | Create Exact Statistics/Generate Histograms/Eval. Structure | |
| 9 | A | Estimate Statistics with Auto Sample Size | |
| 10 | AH | Generate Statistics with Auto Sample Size and Histograms | |
| 11 | AI | Statistics with Auto Sample + Structure Eval. of Indexes | |
| 12 | AX | Statistics with Auto Sample + Histograms + Structure Eval. | |
| 13 | DB6B | DB2/UDB: Statistics Basis for Tables and Indexes (Standard) | |
| 14 | DB6T | DB2/UDB: Basis Statistics for Tables | |
| 15 | DB6I | DB2/UDB: Basis Statistics for Indexes | |
| 16 | DB6A | DB2/UDB: Distribution Frequency for Tables and Indexes | |
| 17 | DB6D | DB2/UDB: Distribution Frequency for Tables | |
| 18 | DB6X | DB2/UDB: Distribution Frequency for Indexes | |
| 19 | DB6E | DB2/UDB: Distribution Frequency: Tables, Basis for Indexes | |
| 20 | DB6Y | DB2/UDB: Basis for Tables, Distribution Frequency Indexes | |
History
| Last changed by/on | SAP | 20051219 |
| SAP Release Created in |