| 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 |