Hierarchy
SAP_BASIS (Software Component) SAP Basis Component⤷
BC-DB-DB4 (Application Component) DB2 for AS/400⤷
STU4 (Package) CCMS / AS/400
Basic Data
| Data Element | QQIDXD |
| Short Description | iSeries: Key Fields for the Advised Index |
Data Type
| Category of Dictionary Type | D | Domain |
| Type of Object Referenced | No Information | |
| Domain / Name of Reference Type | QQIDXD | |
| Data Type | CHAR | Character String |
| Length | 255 | |
| Decimal Places | 0 | |
| Output Length | 255 | |
| 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 | 11 | Key Fields |
| Medium | 21 | Key Fields |
| Long | 41 | Key Fields |
| Heading | 55 | Key Fields |
Documentation
Definition
QQIDXD contains the key fields for the index advised.
This information is only available for records with QQRID 3000, 3001 and 3002.
Note
In the database, QQIDXD is a field of type CHAR(1000). Because in DDIC it has to be defined as CHAR(255), this field can only be accessed in total by using EXEC SQL; the first 255 characters of this field can be accessed via ABAP SQL.
Example
The native SQL statement
Select a.qqtln, a.qqtfn, a.qqptln, a.qqptfn, a.qqidxd, b.qqsttx
from LIB/qqq3000 a, LIB/qqq1000 b
where a.qqjfld = b.qqjfld and a.qqucnt = b.qqucnt
and a.qqidxa = 'Y'
(LIB is the library name of the SAP System)
lists all queries where the optimizer chose to perform a table scan and advised the creation of a permanent index.
History
| Last changed by/on | SAP | 20070813 |
| SAP Release Created in |
