Quote Originally Posted by marist89
Mviews are great, except when they're not.
Answers like this are why you are a supper genious!!!

If I had to take a swag at it I would say that they are best for data that does not change often. I haven't worked with them lately, but when I was researching them, I found that normal views worked better for the data and queries that I was working with at the time, and yes I did have query rewrite turned on.