作业帮multicube vs big cube?
来源：学生作业帮 编辑：作业帮 分类：英语作业 时间：2024/05/29 22:04:38
multicube vs big cube?
scenerio 1.1 query 1 cube (eg.many periods)scenario 2.1 query 1 multicube 1 cube per periodfor reasons of comparations i can have 1 query 1 cube per periodwhich is better or more fast or is the same?TIA
scenerio 1.1 query 1 cube (eg.many periods)scenario 2.1 query 1 multicube 1 cube per periodfor reasons of comparations i can have 1 query 1 cube per periodwhich is better or more fast or is the same?TIA
If the criteria to divide the cube is the period you don't need several cubes and a multicube. You can just have one cube and partition it by period. In that case, the queries run in parallel (like one you have a multicube) and the uploads as well. And you don't get those constraints that TFR pointed out (once you partition it, you forget it; you treat it as a standard cube).Leandro 查看原帖