How much space is it using up? To do a complete refresh is going to demand a certain amount of temp space, and there's not a lot you can do about it. You might consider not doing complete refresh, as vinit suggests. Perhaps you could describe how data is loaded to the master table and what the exact MV query is, and we could think about whether partitioning, and implementing partition change tracking would be beneficial.