I think Igor largely nails it. I'd concentrate the aggregations into the view. That's the stuff that is going to be the most costly in your queries, so doing that work ahead of time is best. As for the rest, it's hard to offer advice without seeing the code and the structures. Read my books? Not great help, but that's about all I can add here.