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.
