Khaja_Zaffer
Esteemed Contributor

isnt materilized view recompute on every run? did you try with incremental processing? 

Do you have any complex joins?