开发者

Improve the effeciency of query processing in a improved version of star schema

I have a fact table , measure table and and connected to them are dimension tables. It is just a slight modification to star schema. But know as the no of joins 开发者_开发技巧are increasing due to introduction of measure table the query processing time is increased. Can any one suggest some approach to improve efficiency of query processing? Like adding some bridges between diemensions etc

Thanks


Store aggregated version of your data by frequently used dimensions, so that you can leave them out of joins that need to run faster.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜