Materlizedview or CTAS – Need help on Design approach
Hi All,
We are having a table which is called master table(MASTER). This table contains 20 months data always. We need to maintain another table(CP_MASTER) on top of MASTER table .This table would be used for reporting purpose. This MASTER table will updated weekly or monthly once so we don’t want anything to be impacted on reporting queires while refereshing MASTER table. We are planning to follow either one of approach.
Option 1 : CTAS : Creating table as CP_MASTER using CTAS and create indexes on new table .
Option 1 : Materlizedviews : Weekly or Monthly referesh CP_MASTER table using Materlizedviews and create indexes on Meterlized views.
Could you please suggest which approach would be good and reliable.
Thanks,
Users