Anyone can offer any solutions for huge data. Our claim data is huge even though only 2 years data. For SSRS report, some parameters one year results are over 100 million rows, takes forever to deliver. e.g. some reports are 40 columns, need to join 20 tables, very slow.
We are thinking to make two flat tables, pre-join all the tables
or make a star schema data warehouse ...
Please give me some suggestions, if these solutions work or you have any better ones.
Thank you in advance.