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:
(nl_join (t_scan t1) (store_ind (t_scan t2) ) )
The store_ind abstract plan
operator must be placed on the inner side of an nl_join.
It can be placed over any abstract plan; there is no longer a single table
scan limitation. The legacy (scan (store... ))
syntax
is still accepted.