I have a couple of materialized views that i currently refresh on demand.
I need to have them automatically refreshed.
how can i alter these mviews without having to force a complete refresh when i alter?
i have a couple of views that i want to refresh on sundays, a couple that i want to refresh daily.
another question is, can i refresh multiple views at the same time?
say, i have 5, 3 gig tables that i want to refresh at 3am every night.
the source tables are on a mssql server.
will my bottle neck be processing power at the mssql server? or network bandwidth.