This view is materialized during query processing:
create view v3 as select distinct * from t3
This query performs a join with the materialized view:
select * from t1, v3 where c11 = c31
A first step materializes the view v3 into a worktable. The second joins it with the main query table t1 :
( plan
( store Worktab1
( t_scan ( table t3 ( in (view v3 ) ) ) )
)
( g_join
( t_scan t1 )
( t_scan ( work_t Worktab1 ) )
)
)