SAP ABAP Table SQIXADVDB4 (Structure for Index Advised Information)
Hierarchy
☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-DB4 (Application Component) DB2 for AS/400
     ⤷ STU4 (Package) CCMS / AS/400
Basic Data
Table Category INTTAB    Structure 
Structure SQIXADVDB4   Table Relationship Diagram
Short Description Structure for Index Advised Information    
Delivery and Maintenance
Pool/cluster      
Delivery Class      
Data Browser/Table View Maintenance     Display/Maintenance Allowed with Restrictions 
Components
     
Field Key Data Element Domain Data
Type		 Length Decimal
Places		 Short Description Check
table
1 TABLE_SCHEMA TAB_SCHEMA QQTLN CHAR 10   0   iSeries: SQL schema name of table or view  
2 TABLE_NAME TNAME AS4TAB CHAR 30   0   Table name *
3 PARTITION_NAME DB4PARTNAME DB4PARTNAME CHAR 10   0   DB2/400: Name of a Table Partition  
4 INDEX_TYPE CHAR14 CHAR14 CHAR 14   0   Text field length 14  
5 LAST_ADVISED QQTIME QQTIME CHAR 26   0   iSeries: Record Creation Timestamp (Database Monitor)  
6 TIMES_ADVISED SDB4_INT8 SDB4_INT8 DEC 19   0   Alt. Type for INT8 (-9223372036854775808..922337203685476)  
7 EST_CREATE_TIME INT4 INT4 INT4 10   0   Natural number  
8 REASON_ADVISED QQRCODIDU QQRCOD CHAR 2   0   iSeries: Reason Code for Used Index (Database Monitor)  
9 LOGICAL_PAGESIZE INT4 INT4 INT4 10   0   Natural number  
10 MOST_EXP_QUERY INT4 INT4 INT4 10   0   Natural number  
11 AVG_QUERY_EST INT4 INT4 INT4 10   0   Natural number  
12 TABLE_SIZE SDB4_INT8 SDB4_INT8 DEC 19   0   Alt. Type for INT8 (-9223372036854775808..922337203685476)  
13 NLSS_TABLENAME SYS_TNAME QCHAR10 CHAR 10   0   iSeries: iSeries system name of table or view  
14 NLSS_TABLESCHEMA TAB_SCHEMA QQTLN CHAR 10   0   iSeries: SQL schema name of table or view  
15 MTI_USED SDB4_INT8 SDB4_INT8 DEC 19   0   Alt. Type for INT8 (-9223372036854775808..922337203685476)  
16 MTI_CREATED INT4 INT4 INT4 10   0   Natural number  
17 LAST_MTI_USED QQTIME QQTIME CHAR 26   0   iSeries: Record Creation Timestamp (Database Monitor)  
18 KEY_COLS_ADVISED     STRG 16000   0    
19 LEADING_COL_KEYS     STRG 16000   0    
20 AVG_QUERY_EST_MICR SDB4_INT8 SDB4_INT8 DEC 19   0   Alt. Type for INT8 (-9223372036854775808..922337203685476)  
History
Last changed by/on SAP  20130604 
SAP Release Created in 710