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.STORE_SALES | |||||
---|---|---|---|---|---|---|
Index Name | ||||||
DB2ADMIN.SQL090403183259140 | ||||||
Key Column Name | Key Order | COLCARDF | MCARDF | FF | Predicate | |
SS_ITEM_SK | ASCENDING | -1 | -1 | |||
SS_TICKET_NUMBER | ASCENDING | -1 | -1 | |||
Table Name | TPCDS.DATE_DIM | |||||
Index Name | ||||||
DB2ADMIN.SQL090403183255920 | ||||||
Key Column Name | Key Order | COLCARDF | MCARDF | FF | Predicate | |
D_DATE_SK | ASCENDING | -1 | -1 | 0.040000 | Q2.SS_SOLD_DATE_SK = Q1.D_DATE_SK |