物化是其于其表创建的,其表已创建索引,还用管物化视图 楼主可以自已测试: CREATE MATERIALIZED VIEW sales_mv BUILD IMMEDIATE REFRESH FAST ON COMMIT AS SELECT t.calendar_year, p.prod_id, SUM(s.amount_sold) AS sum_sales FROM times t, products p, sales s WHERE t.time_id = s.time_id AND p.prod_id = s.prod_id GROUP BY t.calendar_year, p.prod_id; 像上面的例子,你根本不能对time_id创建索引,它属于times其表上
楼主可以自已测试:
CREATE MATERIALIZED VIEW sales_mv
BUILD IMMEDIATE
REFRESH FAST ON COMMIT
AS SELECT t.calendar_year, p.prod_id,
SUM(s.amount_sold) AS sum_sales
FROM times t, products p, sales s
WHERE t.time_id = s.time_id AND p.prod_id = s.prod_id
GROUP BY t.calendar_year, p.prod_id;
像上面的例子,你根本不能对time_id创建索引,它属于times其表上
还有我用了refresh fast可是不管用,源表改变很久了,可是物化视图里还没变。我已经建了物化视图log了。