数据聚簇对于数据仓库查询性能的影响尤其显著,因为常常在一个查询中获取许多行。
Data clustering can have an especially large impact on data warehouse query performance, because rows are often retrieved in large Numbers.
另外的解决方案,取决于具体的错误,可能是手工重建非聚簇索引,如果数据是静态的手工扔掉和重新载入表,诸如此类。
Additional solutions, depending on the errors, may be to manually rebuild non-clustered indexes, manually drop and reload a table if the data is static, and so on.
为了支持这样的查询,管理员可以通过使用多维聚簇让DB 2按这些维组织sales表中的行。
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.
应用推荐