Table Name | | | | | | | TPCDS.CUSTOMER_DEMOGRAPHICS | | | | | | | | Index Name | | | | | |
---|
| DB2ADMIN.SQL090403183255770 | | | | | |
| Key Column Name | Key Order | COLCARDF | MCARDF | FF | Predicate |
---|
| CD_DEMO_SK | ASCENDING | -1 | -1 | 0.022222 | Q3.CD_DEMO_SK = Q5.C_CURRENT_CDEMO_SK |
Table Name | | | | | | |
---|
TPCDS.CUSTOMER | | | | | | | | Index Name | | | | | |
---|
| DB2ADMIN.SQL090403183257350 | | | | | |
| Key Column Name | Key Order | COLCARDF | MCARDF | FF | Predicate |
---|
| C_CUSTOMER_SK | ASCENDING | -1 | -1 | | |
Table Name | | | | | | |
---|
TPCDS.CUSTOMER_ADDRESS | | | | | | | | Index Name | | | | | |
---|
| DB2ADMIN.SQL090403183255500 | | | | | |
| Key Column Name | Key Order | COLCARDF | MCARDF | FF | Predicate |
---|
| CA_ADDRESS_SK | ASCENDING | -1 | -1 | 0.040000 | Q5.C_CURRENT_ADDR_SK = Q4.CA_ADDRESS_SK |