Database DataWarehousing (MOSC)

MOSC Banner

creating a materialized view takes a lot of time

edited Dec 1, 2013 5:31PM in Database DataWarehousing (MOSC) 4 commentsAnswered
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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center