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      
DB2ADMIN.DEPARTMENT      
 Index Name     
 DB2ADMIN.IDX904022138360000     
 Key Column NameKey OrderCOLCARDFMCARDFFFPredicate
 LOCATIONASCENDING11  
 DEPTNODESCENDING14-1  
 Index Name     
 SARAVIND.PK_DEPARTMENT     
 Key Column NameKey OrderCOLCARDFMCARDFFFPredicate
 DEPTNOASCENDING1414  
 Index Name     
 SARAVIND.XDEPT2     
 Key Column NameKey OrderCOLCARDFMCARDFFFPredicate
 MGRNOASCENDING99  
 Index Name     
 SARAVIND.XDEPT3     
 Key Column NameKey OrderCOLCARDFMCARDFFFPredicate
 ADMRDEPTASCENDING33  
Table Name      
DB2ADMIN.PROJECT      
 Index Name     
 DB2ADMIN.IDX904022138410000     
 Key Column NameKey OrderCOLCARDFMCARDFFFPredicate
 DEPTNOASCENDING880.071429Q1.DEPTNO = Q3.DEPTNO
     0.125000Q4.WORKDEPT = Q3.DEPTNO
 RESPEMPASCENDING17-10.023810Q3.RESPEMP = Q4.EMPNO
     0.058824Q2.MGRNO = Q3.RESPEMP
 PROJNAMEASCENDING20-1  
 PROJNOASCENDING20-1  
 MAJPROJASCENDING8-1  
 Index Name     
 SARAVIND.PK_PROJECT     
 Key Column NameKey OrderCOLCARDFMCARDFFFPredicate
 PROJNOASCENDING2020  
 Index Name     
 SARAVIND.XPROJ2     
 Key Column NameKey OrderCOLCARDFMCARDFFFPredicate
 RESPEMPASCENDING17170.023810Q3.RESPEMP = Q4.EMPNO
     0.058824Q2.MGRNO = Q3.RESPEMP
Table Name      
DB2ADMIN.EMPLOYEE      
 Index Name     
 SARAVIND.PK_EMPLOYEE     
 Key Column NameKey OrderCOLCARDFMCARDFFFPredicate
 EMPNOASCENDING42420.023810Q3.RESPEMP = Q4.EMPNO
     0.023810Q4.EMPNO = Q2.MGRNO
 Index Name     
 SARAVIND.XEMP2     
 Key Column NameKey OrderCOLCARDFMCARDFFFPredicate
 WORKDEPTASCENDING880.071429Q4.WORKDEPT = Q1.DEPTNO
     0.125000Q4.WORKDEPT = Q3.DEPTNO
Table Name      
DB2ADMIN.DEPARTMENT      
 Index Name     
 DB2ADMIN.IDX904022138360000     
 Key Column NameKey OrderCOLCARDFMCARDFFFPredicate
 LOCATIONASCENDING11  
 DEPTNODESCENDING14-1  
 Index Name     
 SARAVIND.PK_DEPARTMENT     
 Key Column NameKey OrderCOLCARDFMCARDFFFPredicate
 DEPTNOASCENDING1414  
 Index Name     
 SARAVIND.XDEPT2     
 Key Column NameKey OrderCOLCARDFMCARDFFFPredicate
 MGRNOASCENDING990.023810Q4.EMPNO = Q2.MGRNO
     0.058824Q2.MGRNO = Q3.RESPEMP
 Index Name     
 SARAVIND.XDEPT3     
 Key Column NameKey OrderCOLCARDFMCARDFFFPredicate
 ADMRDEPTASCENDING33