Serge,

Your response brings up a question. How will the advantages of MDC
tables be leveraged when the clustering column is not related to the
actual data relationships and therefore will not be referenced in any
predicates?

Thanks.

Lew

Serge Rielau wrote:
> Make your fact table a multi-dimensional-cluster.
> That's ll do. I agree that DPF would be overkill.
> If you don't have a low cardinality column that offers itself up for
> MDC, just add another column e.g.
> yearmonth GENERATED ALWAYS AS (INTEGER(date)/100)
> Then cluster on the yearmonth column.
> If you have 3 years worth of data this would partition the table into
> 3 * 12 => 36 slices.
>
> Cheers
> Serge
>
> --
> Serge Rielau
> DB2 Solutions Development
> IBM Toronto Lab
>
> IOD Conference
> http://www.ibm.com/software/data/ond...ness/conf2006/