Materilized View Dropping vs.Truncating.
occurs during this job. To reduce the amount of logging, I have added the NOLOGGING clause to the
creation of the materialized view. So I started to think, what is better:
- A) Drop the materialized view (without a purge) the create the table or...
- Truncate the materialized view then insert to the materialized view.
What is the least contentious operation? What operations would cause the least about of log switching?
Thanks.