3,492
社区成员
发帖
与我相关
我的任务
分享
create materialized view mv_x
REFRESH FAST ON demand
as
select 1 x, rowid rid, a from t_wp_xh
union all
select 2 x, rowid rid, a from t_wp_cx
--try it
CREATE MATERIALIZED VIEW MVB_WP_CXXH REFRESH FORCE or REFRESH COMPLETE
AS
select xtm,htm from T_WP_CX
union all
select xtm,htm from T_WP_XH
CREATE MATERIALIZED VIEW MVB_WP_CXXH REFRESH FAST ON DEMAND
AS
select xtm a,htm b from T_WP_CX t1,T_WP_XH t2 where (t1.a<>t2.a or t1.b<>t2.b);
--试一下:
CREATE MATERIALIZED VIEW MVB_WP_CXXH REFRESH FAST ON DEMAND
AS
select xtm,htm from T_WP_CX,T_WP_XH;
CREATE MATERIALIZED VIEW MVB_WP_CXXH REFRESH with rowid
AS
select xtm,htm from T_WP_CX
union all
select xtm,htm from T_WP_XH
CREATE MATERIALIZED VIEW MVB_WP_CXXH REFRESH FAST ON DEMAND
AS
select xtm,htm from T_WP_CX
union all
select xtm,htm from T_WP_XH