create materialized view cust_q
refresh fast start with sysdate next sysdate+1/8640
with primary key
as
select a.rowid rowaid,b.rowid rowbid,c.rowid rowcid,
A.CUST_ID,A.CUST_SEQ,A.CUST_UID,A.PARENT_ID,A.PARTY_ID,B.PARTY_TYPE,B.NAME,B.NAME_OTHER,
A.CUST_VOCA_ID,B.LOCAL_NET_ID,B.AREA_ID,c.CUST_LEVEL_ID,
c.CUST_PRPTY_ID,c.MARKETING_PRPTY_ID , c.SERVICE_PRPTY_ID,A.HALT,A.VIP_CODE,A.MANAGE_STS,A.STS,A.STS_DATE,
A.SYS_USER_ID,A.MOD_REASON,A.LAST_MOD_DATE,A.CREATE_DATE,A.REMARKS
fromCUST A,PARTY B ,cust_gc
where A.PARTY_ID = B.PARTY_ID
and a.cust_id=c.cust_id
and a.sts’P’
and b.sts’P’
and c.sts’P’;
create unique INDEX I_CUST_Q_CUST_IDON CUST_Q (CUST_ID )
TABLESPACE UCI_QURY_IND_01;
这个物化视图只是做了三个表的简单关联,应用于一个大型的电信应用系统,随着数据量的日益增大,出错频率越来越高。并且手工刷新不了,只有重建。但是对于一个时时的交易平台,简直是一件太可怕的事情了,大家遇到过这样的情况吗? 急盼高人指教一二!
|