| Index name | Table name | Attributes | ||
| XPK_MONTH | UNIQUE DESC | MONTH | YEAR_ID | |
| MONTH_ID | ||||
| xsale_year | SALE | YEAR_ID | ||
| XPK_SALE | UNIQUE | SALE | PRODUCT_ID | |
| STORE_ID | ||||
| YEAR_ID | ||||
| MONTH_ID | ||||
| xStoreID | UNIQUE | STORE | STORE_ID | |
| xProductName | PRODUCT | PRODUCT_NAME | ||
| xsale_store | SALE | STORE_ID | ||
| xProductID | UNIQUE | PRODUCT | PRODUCT_ID | |
| xsale_reg | SALE | REGION_ID | ||
| xsale_prod | SALE | PRODUCT_ID | ||
| xStoreName | STORE | STORE_NAME | ||