oracle
-
编辑 删除
创建快速刷新物化视图
1、初始化环境SYS@PROD1>create materialized view sh.prod_cost_mv as select time_id,prod_subcategory,sum(unit_cost) as sum_units from costs c,products p where c.prod_id=p.prod_id group by time_id,prod_subcategory;2、开启重写查询参数SYS@PROD1>show parameter query;NAME  ...
