Are cartesian (cross) joins with where statement still slower than inner joins?
Compare these two queries: select b.prod_name, b.prod_category, a.transaction_amt, a.transaction_dt from transactions a, prod_xref b where a.prod_id = b.id VS. select b.prod_name, b.prod_category, a.transaction_amt, a.transaction_dt from transactions a inner join b.prod_xref…