SAP ABAP Data Element QQCIU (iSeries: Index Usage (Database Monitor))
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 QQCIU
Short Description iSeries: Index Usage (Database Monitor)  
Data Type
Category of Dictionary Type D   Domain
Type of Object Referenced     No Information
Domain / Name of Reference Type QQDEC150    
Data Type DEC   Counter or amount field with comma and sign 
Length 15    
Decimal Places 0    
Output Length 19    
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 Ind. Usage 
Medium 21 Index Usage 
Long 41 Index Usage 
Heading 55 Index Usage 
Documentation

Definition

QQCIU is the number of times a statement was implemented using an existing access path (index).

If the most expensive execution of a statement was thus implemented, more details about the table scan performed (for example, why an index was used) are found in the record in table SQ3001_DB4 corresponding to that statement.

Example

The Open SQL statement (with an appropriate internal table declaration for itab) would list all statements (library/SQL package/statement name), physical files (tables), and the reason code for using the index accessed which were implemented using an existing index when the most expensive execution occurred:
select b~qqplib b~qqpnam b~qqsnam a~qqptln a~qqptfn a~qqrcod
into corrseponding fields of table itab
from SQ3001_DB4 as a
inner join SQ1000_DB4 as b
where a~qqkey = b~qqkey.

History
Last changed by/on SAP  20070813 
SAP Release Created in