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.CUSTOMER_DEMOGRAPHICS      
 Index Name     
 DB2ADMIN.SQL090403183255770     
 Key Column NameKey OrderCOLCARDFMCARDFFFPredicate
 CD_DEMO_SKASCENDING-1-10.022222Q3.CD_DEMO_SK = Q5.C_CURRENT_CDEMO_SK
Table Name      
TPCDS.CUSTOMER      
 Index Name     
 DB2ADMIN.SQL090403183257350     
 Key Column NameKey OrderCOLCARDFMCARDFFFPredicate
 C_CUSTOMER_SKASCENDING-1-1  
Table Name      
TPCDS.CUSTOMER_ADDRESS      
 Index Name     
 DB2ADMIN.SQL090403183255500     
 Key Column NameKey OrderCOLCARDFMCARDFFFPredicate
 CA_ADDRESS_SKASCENDING-1-10.040000Q5.C_CURRENT_ADDR_SK = Q4.CA_ADDRESS_SK