› Fóruns › Banco de dados Oracle › Materialyzed View Demorada !!! › Materialyzed View Demorada !!!
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 ??