Legend | |
---|---|
Name | Description |
COLCARDF | Estimated number of distinct values in the column. |
FF | Filter factor. |
Index Name | Index name. |
Key Column Name | Key column name. |
Key Order | Key order. |
MCARDF | Estimated number of distinct values for the multi-column group. |
Predicate | Predicate text. |
Table Name | Table name. |
Table Name | TPCDS.REPAIR | |||||
---|---|---|---|---|---|---|
Index Name | ||||||
DB2ADMIN.SQL090403183259280 | ||||||
Key Column Name | Key Order | COLCARDF | MCARDF | FF | Predicate | |
R_REPAIR_TICKET_SK | ASCENDING | 0 | 0 | |||
Table Name | TPCDS.CATALOG_RETURNS | |||||
Index Name | ||||||
DB2ADMIN.SQL090403183258410 | ||||||
Key Column Name | Key Order | COLCARDF | MCARDF | FF | Predicate | |
CR_ITEM_SK | ASCENDING | 0 | 0 | 1.000000 | Q1.R_ITEM_SK = Q2.CR_ITEM_SK | |
CR_ORDER_NUMBER | ASCENDING | 0 | 0 | 0.333333 | 10 < Q2.CR_ORDER_NUMBER | |
1.000000 | Q1.R_ORDER_NUMBER = Q2.CR_ORDER_NUMBER |