17,140
社区成员




create materialized view test
refresh fast on demand
as
select
t1.slr,
t2.bzxx,
t1.qdrq,
t1.ywbh,
......
t1.rowid rid1,
t2.rowid rid2
from [表1] t1,
[物化视图] t2
where t1.qdrq = t2.qdrq(+)
and t1.ywbh = t2.ywbh(+);