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.STORE_SALES      
 Index Name     
 DB2ADMIN.SQL090403183259140     
 Key Column NameKey OrderCOLCARDFMCARDFFFPredicate
 SS_ITEM_SKASCENDING-1-1  
 SS_TICKET_NUMBERASCENDING-1-1  
Table Name      
TPCDS.DATE_DIM      
 Index Name     
 DB2ADMIN.SQL090403183255920     
 Key Column NameKey OrderCOLCARDFMCARDFFFPredicate
 D_DATE_SKASCENDING-1-10.040000Q2.SS_SOLD_DATE_SK = Q1.D_DATE_SK