Optimizer: Eliminate Cross Join Rule

[universalmind303]

cross joins followed by filter can often be replaced as inner joins.
These style of queries were very popular, and are found among most tpc queries.

select ... from a, b where a.x = b.y and b.xx = 100;

this can usually be rewritten as

select ...
from a
inner join b on a.x = b.y 
where b.xx = 100