Oracle#1 Materialized view performance improvement on complete refresh
This video explains how to improve performance of materialized view while doing complete refresh in oracle. Here i have created table and materialized view and described the refresh options. Also demonstrated with small script to compare the performance impact
Oracle version used: Oracle 11gR2
Oracle client tool: Oracle SQL Developer
Try to create our own table with more no of rows and observe the performance impact.