Yes you are correct, I am using nested views that cotains CTEs to process data from various source tables and views. So can't use materilized views. I believe Materilized view...