Simpson's Paradox as per this article shows the danger of looking for data that fits your agenda. You can take almost any set of data, twist and contort it to...

If the tables were not being updated to often wouldn't an indexed view allow you to not have the processing of the view unless the the data changes?