We have a datamart that receives approx. 6 million records a day into two main fact tables and is a complete beast to report off of. I am fairly certain that the design can be improved but am not sure where to start. Does anyone have any pointers or suggests what to read or what to look at?
Any information is greatly appreciated and thanks in advance to those who do respond.