CREATE MATERIALIZED VIEW "OVSD"."GSP_RELATEDEVENTS1"  
NOLOGGING 
 REFRESH FORCE  
--START WITH SYSDATE   NEXT SYSDATE + 3/1440
                         AS                         
  SELECT DISTINCT ser_id AS R_SER_ID,
    WM_CONCAT (REL_NAME) AS R_NAME
  FROM sd_servicecalls,
    cdm_serv_evt_relations,
    GSP_EVENTS
  WHERE sre_from = ser_oid
  AND sre_to     = EVENT_TO_OID
  GROUP BY ser_id;
  
  ALTER MATERIALIZED VIEW "OVSD"."GSP_RELATEDEVENTS1" COMPILE;
  
  drop materialized view GSP_RELATEDEVENTS1;
  
  create index ser_id_mv_idx on GSP_RELATEDEVENTS1(r_ser_id);
  
  analyze table GSP_RELATEDEVENTS1 compute statistics