creating a materialized view takes a lot of time
Materialized view is being created with a select statement from a database link.
Is there any alternate for this or to optimize the performance?
CREATE MATERIALIZED VIEW MMD.MV_FRZ_OFFICE_ASSIGNMENT TABLESPACE MMD_DATA BUILD IMMEDIATE USING INDEX TABLESPACE MMD_DATA REFRESH FORCE ON DEMAND WITH ROWID AS SELECT person_id, period_name, location_type, office_assignment_id, eff_date,location_code, location_code_override,record_value_change_flag, eff_date_change_flag, src_purge_flag, src_add_date,src_update_date,ors_create_tstamp,ors_change_tstamp FROM ors.frz_office_assignment@mmdors.world WHERE TO_DATE(P
0