LOG en Vista materializada

[samotin]

Hola,

a ver que te parece, es un poco larga. La version es:

10g 10.2.0.3

Ahí va la consulta:

Código:

  CREATE MATERIALIZED VIEW "RECOR"." VM_PARTE_SEC_SEMANAL "
  ORGANIZATION HEAP PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS NOLOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  TABLESPACE "TS_SEC"
  PARALLEL (DEGREE 10 INSTANCES 2)
  BUILD IMMEDIATE
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  TABLESPACE "TS_SEC"
  REFRESH FAST ON COMMIT
  USING DEFAULT LOCAL ROLLBACK SEGMENT
  ENABLE QUERY REWRITE
  AS select t.DATOS_SEMANALES SEMANALES,
t.NOMBRE,
t.DATOS_ANY,
to_char(t.DATOS_ANY) NOM_ANYO_SEMANAL,
ID_SECI,
ID_NUMERO,
ID_VERSION,
ID_BIT,
ID_ZONA,
CONTAB,
ID_BANDERA,
ID_SUBAREA,
ID_SECCION,
MARCA,
HARD,
ID_HOJA,
ID_PRODUC,
sum(IMPORTE_PUNTO) IMPORTE_PUNTO,
sum(decode(ID_ZONA, 40, 1, 50, 1, 0)*IMPORTE_PUNTO) IMPORTE_ACT,
sum(IMPORTE_PUNTO_PIG) IMPORTE_PUNTO_PIG,
sum(decode(ID_ZONA, 40, 1, 50, 1, 0)*IMPORTE_PUNTO_PIG) IMPORTE_ACT_PUNTO,
sum(IMPORTE_PP_HIST) IMPORTE_PP_HIST,
sum(decode(ID_ZONA, 40, 1, 50, 1, 0)*IMPORTE_PP_HIST) IMPORTE_HISTORICO,
sum(IMPORTE_AA) IMPORTE_AA,
sum(decode(ID_ZONA, 40, 1, 50, 1, 0)*IMPORTE_AA) IMPORTE_VUELTA
from comercial_margon c,
trimestral t
where c.DAT_CONTAB = t.DAT_DIA
group by t.DAT_SEMANA ,
t.NOMBRE,
t.DATOS_ANY,
to_char(t.DATOS_ANY),
ID_SECI,
ID_NUMERO,
ID_VERSION,
ID_BIT,
ID_ZONA,
CONTAB,
ID_BANDERA,
ID_SUBAREA,
ID_SECCION,
MARCA,
HARD,
ID_HOJA,
ID_PRODUC

Muchas gracias