Change optimizer to prefer key lookups before table scan
Change table scans to be done after tables with constrains on scanned table