In USoft V9.1, if we use an Usage outer join in combination with batch parameterset, it looks like the optimizer removes the outer join instruction and executes an inner join, e.g.
update p_set par
set column_1 = (
select round(nvl(sdurd.duration, adv.value))
from ops_stage_duration_default sdurd
, app_default_values adv
where par.from_poi_id = sdurd.from_poi_id (+)
and par.to_poi_id = sdurd.to_poi_id (+)
and ptpc.from_poi_id = par.from_poi_id
and adv.name = 'STAGE_DEFAULT_DURATION'
)
)
Start Benchmark and you’ll see the outer join removed
Is this intended behavior?