In this query, t2 is very large, and has no index:
select *
from t1, t2
where c11 > 0
and c12 = c21
and c22 = 0
The abstract plan that specifies the reformatting strategy on t2 is:
( g_join
(t_scan t1
(scan
(store Worktab1
(t_scan t2)
)
)
)
In the case of the reformatting strategy, the store operator is an operand of scan. This is the only case when the store operator is not the operand of a plan operator.
