In either case, consider adding additional logic in the join expressions to the fake fact table that will reduce the range of join key values that can be returned from the dimension tables.
在这两种情况下，考虑在伪事实表的连接表达式中添加额外的逻辑，这会缩小从维度表返回的连接键值的范围。
Multi DIMENSIONAL CLUSTERING (MDC) - organizing data in table (or range of a table) by multiple key values.
MULTIDIMENSIONALCLUSTERING (MDC)——根据多个键值组织表(或一个表中的范围)中的数据。
RANGE/TABLE PARTITIONING (Available with DB2 9) - splitting data by key range over multiple physical objects within a logical database partition.
RANGE/TABLEPARTITIONING（DB29提供） ——根据键范围将数据划分到一个逻辑数据库分区中的多个物理对象上。
RANGE/TABLE PARTITIONING (Available with DB2 9) - splitting data by key range over multiple physical objects within a logical database partition.
RANGE/TABLEPARTITIONING（DB29提供） ——根据键范围将数据划分到一个逻辑数据库分区中的多个物理对象上。
应用推荐