开发者

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

开发者 https://www.devze.com 2023-04-04 18:54 出处:网络
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 in

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

精彩评论

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