Chapter 14 Using Materialized Views
Generally Materialized views is used in warehouse.
it must be refreshed.
Three ways to refresh:
complete:Executes the SQL-query again;it's expensive.
fast:apply those changes to the materialized view since the most recent;it's fast;it need materialized view logs.
force:First, try fast refresh,if fails, it performs a complete refresh instead.
P388 Creating materialized views;
P390 Monitoring
P391 troubleshooting
oracle10g ocp学习笔记系列之CH14Materialized Views
最新推荐文章于 2024-04-24 09:15:43 发布