Re: tough choices

Actually partitioning (DB2 UDB for LUW calls is organization to curb confusion) of a table is orthogonal to partitioning of the database. Let's use multi-dimensional clustering (MDC) as one example of "organization" since it is supported in DB2 UDB for LUW at present. MDC is supported in DB2 + DPF. What happens is that first the table is hash partitioned across the database partitions, then MDC kicks in and clusters the data in extends (which are a subdivision of a tablespace). Now, you can add "range partitioning" or "fragmented tables" to that and you end up with a hierarchie.
First comes database partitioning, then comes range partitioning and finally multidimensional clustering.

I'm not certain if adding anny other partitioning but hash on the database level is a good idea. It invites data skew and would be a maintenance nightmare to add more database partitions.

Cheers
Serge

-- 
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab