Hi, Is refreshing a materialized view in 9.3 basically:
delete from mat_view; insert into mat_view select * from base_view; Or is it more efficient? If no rows have changed, will new tuples be written on a refresh? Joe
Hi, Is refreshing a materialized view in 9.3 basically:
delete from mat_view; insert into mat_view select * from base_view; Or is it more efficient? If no rows have changed, will new tuples be written on a refresh? Joe