Using multi-dimensional clustering for query performance.
使用多维聚簇提高查询性能。
As in previous releases, administrators use the ORGANIZE BY dimension (...) clause of the CREATE TABLE statement to specify multi-dimensional clustering.
与以前的版本一样，管理员使用CREATEtable语句的ORGANIZEBYDIMENSION(…)子句指定多维聚簇。
To support such a query, an administrator can use multi-dimensional clustering to instruct DB2 to physically organize rows in the SALES table by these dimensions.
为了支持这样的查询，管理员可以通过使用多维聚簇让DB 2按这些维组织sales表中的行。
For best performance and minimal space consumption, we recommend using database partitioning, range partitioning, compression, and multi-dimensional clustering.
为了获得更好的性能和最小化空间消耗，我们建议使用数据库分区、范围分区、压缩和多维集群。
With DB2 9.7, tables containing XML columns can participate in multi-dimensional clustering, provided that the clustering dimensions are defined by relational columns.
在DB 2 9.7中，包含xml列的表可以应用多维聚簇，但是聚簇维必须由关系列定义。
Multi DIMENSIONAL CLUSTERING (MDC) - organizing data in table (or range of a table) by multiple key values.
MULTI DIMENSIONAL CLUSTERING (MDC)——根据多个键值组织表(或一个表中的范围)中的数据。
Multi DIMENSIONAL CLUSTERING (MDC) - organizing data in table (or range of a table) by multiple key values.
MULTI DIMENSIONAL CLUSTERING (MDC)——根据多个键值组织表(或一个表中的范围)中的数据。
应用推荐