IndexScan condition removal

Now when a hash join is performed any condition that are taken care of
by an index scan are left out of the join as to improve performance