[Oracle] Materialized View

Olivier | Code, Tips

Creating a MV :

CREATE MATERIALIZED VIEW <mv_name> 
ENABLE QUERY REWRITE AS
<SQL_query>

Refreshing manualy a MV :

exec DBMS_MVIEW.REFRESH('<mv_name>');

Stats can be calcultated on MV like on table (cf Related Links)