Pular para o conteúdo

Fóruns Banco de dados Oracle Materialyzed View Demorada !!! Materialyzed View Demorada !!!

#91034
ramasine
Participante

    O codigo de criação da view é esse:

    CREATE MATERIALIZED VIEW EDWHRP.VM_FAC_ACT_PEND
    TABLESPACE D4DWH
    PCTUSED 40
    PCTFREE 10
    INITRANS 2
    MAXTRANS 255
    STORAGE (
    INITIAL 160000K
    NEXT 160000K
    MINEXTENTS 1
    MAXEXTENTS UNLIMITED
    PCTINCREASE 0
    FREELISTS 1
    FREELIST GROUPS 1
    BUFFER_POOL DEFAULT
    )
    NOCACHE
    NOLOGGING
    PARALLEL ( DEGREE 4 INSTANCES 1 )
    BUILD DEFERRED
    USING INDEX
    TABLESPACE TDWH
    PCTFREE 10
    INITRANS 2
    MAXTRANS 255
    STORAGE (
    INITIAL 80K
    MINEXTENTS 1
    MAXEXTENTS UNLIMITED
    PCTINCREASE 0
    BUFFER_POOL DEFAULT
    )
    REFRESH COMPLETE ON DEMAND
    WITH ROWID

    Não seria melhor utilizar o fast refresh ??