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 ) ) ) )