Thank you very much for all your answers.

That's what i need.I am going to work with indexed views. Except that i finally decided to add certain computed columns directly to base tables, so that i can focus on aggregate functions in views.