Materialized View
I inherited responsibility for a datawarehouse and it has a materialized view that selects all the columns from one of the fact tables.
There is no aggregation or join.
ON PREBUILT TABLE WITHOUT REDUCED PRECISION REFRESH FORCE ON DEMAND WITH PRIMARY KEY ENABLE QUERY REWRITE AS SELECT..... every_column from fact_table;What could be the purpose?
0