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

来源:学生作业帮助网 编辑:六六作业网 时间:2024/11/17 04:41:12
multicubevsbigcube?scenerio1.1query1cube(eg.manyperiods)scenario2.1query1multicube1cubeperperiodforr

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
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

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
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 查看原帖>>