数据聚簇对于数据仓库查询性能的影响尤其显著,因为常常在一个查询中获取许多行。
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.
一粒霉菌是一簇美不胜收的花朵,一撮星云是无数天体的蚁聚。
A bit of mould is a pleiad of flowers; a nebula is an ant-hill of stars.
应用推荐