Table Name | | | | | | | DB2ADMIN.DEPARTMENT | | | | | | | | Index Name | | | | | |
---|
| DB2ADMIN.IDX904022138360000 | | | | | |
| Key Column Name | Key Order | COLCARDF | MCARDF | FF | Predicate |
---|
| LOCATION | ASCENDING | 1 | 1 | | |
| DEPTNO | DESCENDING | 14 | -1 | | |
| Index Name | | | | | |
---|
| SARAVIND.PK_DEPARTMENT | | | | | |
| Key Column Name | Key Order | COLCARDF | MCARDF | FF | Predicate |
---|
| DEPTNO | ASCENDING | 14 | 14 | | |
| Index Name | | | | | |
---|
| SARAVIND.XDEPT2 | | | | | |
| Key Column Name | Key Order | COLCARDF | MCARDF | FF | Predicate |
---|
| MGRNO | ASCENDING | 9 | 9 | | |
| Index Name | | | | | |
---|
| SARAVIND.XDEPT3 | | | | | |
| Key Column Name | Key Order | COLCARDF | MCARDF | FF | Predicate |
---|
| ADMRDEPT | ASCENDING | 3 | 3 | | |
Table Name | | | | | | |
---|
DB2ADMIN.PROJECT | | | | | | | | Index Name | | | | | |
---|
| DB2ADMIN.IDX904022138410000 | | | | | |
| Key Column Name | Key Order | COLCARDF | MCARDF | FF | Predicate |
---|
| DEPTNO | ASCENDING | 8 | 8 | 0.071429 | Q1.DEPTNO = Q3.DEPTNO |
| | | | | 0.125000 | Q4.WORKDEPT = Q3.DEPTNO |
| RESPEMP | ASCENDING | 17 | -1 | 0.023810 | Q3.RESPEMP = Q4.EMPNO |
| | | | | 0.058824 | Q2.MGRNO = Q3.RESPEMP |
| PROJNAME | ASCENDING | 20 | -1 | | |
| PROJNO | ASCENDING | 20 | -1 | | |
| MAJPROJ | ASCENDING | 8 | -1 | | |
| Index Name | | | | | |
---|
| SARAVIND.PK_PROJECT | | | | | |
| Key Column Name | Key Order | COLCARDF | MCARDF | FF | Predicate |
---|
| PROJNO | ASCENDING | 20 | 20 | | |
| Index Name | | | | | |
---|
| SARAVIND.XPROJ2 | | | | | |
| Key Column Name | Key Order | COLCARDF | MCARDF | FF | Predicate |
---|
| RESPEMP | ASCENDING | 17 | 17 | 0.023810 | Q3.RESPEMP = Q4.EMPNO |
| | | | | 0.058824 | Q2.MGRNO = Q3.RESPEMP |
Table Name | | | | | | |
---|
DB2ADMIN.EMPLOYEE | | | | | | | | Index Name | | | | | |
---|
| SARAVIND.PK_EMPLOYEE | | | | | |
| Key Column Name | Key Order | COLCARDF | MCARDF | FF | Predicate |
---|
| EMPNO | ASCENDING | 42 | 42 | 0.023810 | Q3.RESPEMP = Q4.EMPNO |
| | | | | 0.023810 | Q4.EMPNO = Q2.MGRNO |
| Index Name | | | | | |
---|
| SARAVIND.XEMP2 | | | | | |
| Key Column Name | Key Order | COLCARDF | MCARDF | FF | Predicate |
---|
| WORKDEPT | ASCENDING | 8 | 8 | 0.071429 | Q4.WORKDEPT = Q1.DEPTNO |
| | | | | 0.125000 | Q4.WORKDEPT = Q3.DEPTNO |
Table Name | | | | | | |
---|
DB2ADMIN.DEPARTMENT | | | | | | | | Index Name | | | | | |
---|
| DB2ADMIN.IDX904022138360000 | | | | | |
| Key Column Name | Key Order | COLCARDF | MCARDF | FF | Predicate |
---|
| LOCATION | ASCENDING | 1 | 1 | | |
| DEPTNO | DESCENDING | 14 | -1 | | |
| Index Name | | | | | |
---|
| SARAVIND.PK_DEPARTMENT | | | | | |
| Key Column Name | Key Order | COLCARDF | MCARDF | FF | Predicate |
---|
| DEPTNO | ASCENDING | 14 | 14 | | |
| Index Name | | | | | |
---|
| SARAVIND.XDEPT2 | | | | | |
| Key Column Name | Key Order | COLCARDF | MCARDF | FF | Predicate |
---|
| MGRNO | ASCENDING | 9 | 9 | 0.023810 | Q4.EMPNO = Q2.MGRNO |
| | | | | 0.058824 | Q2.MGRNO = Q3.RESPEMP |
| Index Name | | | | | |
---|
| SARAVIND.XDEPT3 | | | | | |
| Key Column Name | Key Order | COLCARDF | MCARDF | FF | Predicate |
---|
| ADMRDEPT | ASCENDING | 3 | 3 | | |