Thanks for your suggestion.

I agree with you pre aggregation looks the best solution for my problem.

Thanks

Deependra

Table is normalized and and it is very big because of large volume of data. I am not joining only 1 other table which is a reference table in...

I can't create indexed view because there are many conditions that should match.

So if there is any other way to solve my problem , please let me know.

Deependra

To create an indexed view there should not be any union, intersection etc and we can refer only two part name in the indexed view. Data for a year has...

Thanks for your valuable comments.

Data does not change for the historical records. Actually historical records are the main problem, they comprise bulk of data.If I try store aggregate data to...

I agree with you.

Thanks for the comments.

dkhandka 🙂

I understand the normalization concepts and RDBMS rules.

But would like to know good practices or the rule of thumb which we should follow while designing the database of an enterprize...

Thanks for your valuable comments.

dkhandka