Question

Usage outer join in combination with batch parameterset


Badge

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?


0 replies

Be the first to reply!

Reply