
Chapter 4. Using the cube model for summary tables optimization 141
In this section, however, we will expand on the optimization rules and, as an
example, apply these rules on a basic star schema. Note that optimization rules
further extend the base rules and cube model completeness rules and ensure
that the SQL queries created for the metadata can be optimized successfully.
These are the optimization rules for DB2 Cube Views:
Join optimization rules:
– A referential integrity constraint must be defined for the columns that
participate in a join. For example, columns involved in facts-to-dimension
joins and if applicable dimension-to-dimensio ...