Index Report

Legend
NameDescription
COLCARDFEstimated number of distinct values in the column.
FFFilter factor.
Index NameIndex name.
Key Column NameKey column name.
Key OrderKey order.
MCARDFEstimated number of distinct values for the multi-column group.
PredicatePredicate text.
Table NameTable name.

Table Name      
TPCDS.REPAIR      
 Index Name     
 DB2ADMIN.SQL090403183259280     
 Key Column NameKey OrderCOLCARDFMCARDFFFPredicate
 R_REPAIR_TICKET_SKASCENDING00  
Table Name      
TPCDS.CATALOG_RETURNS      
 Index Name     
 DB2ADMIN.SQL090403183258410     
 Key Column NameKey OrderCOLCARDFMCARDFFFPredicate
 CR_ITEM_SKASCENDING001.000000Q1.R_ITEM_SK = Q2.CR_ITEM_SK
 CR_ORDER_NUMBERASCENDING000.33333310 < Q2.CR_ORDER_NUMBER
     1.000000Q1.R_ORDER_NUMBER = Q2.CR_ORDER_NUMBER