It kinda depends what you are trying to achieve. It's a very open ended questions. Perhaps if you add a bit more details it might help, like the purpose of the MView. What youre plans for recovery are in the case of failure. Is it a fast refresh or not. SOmething that will give me some context.