Dependent joins producing a large in predicate will do a linear search over the predicate. The predicate should be marked as all constants and dealt with as a set instead.