Determine automatically when to use data shipment joins

The full pushdown of a dependent join is currently only hint driven. We should allow the optimizer to select the push down more broadly.