Correlated Sub-queries:  Predicate Promotion in CSQs

Correlated Version

select * from ps_jrnl_ln

where business_unit = 'ABC’

and process_instance = 5960

and not exists

( select "X"

from PS_SP_BU_GL_NONVW P

where P.business_unit = ps_jrnl_ln.business_unit

)

Non-Correlated Version

select * from ps_jrnl_ln

where business_unit = 'ABC’

and process_instance = 5960

and not exists

( select "X"

from PS_SP_BU_GL_NONVW P

where P.business_unit =

‘ABC’

)

Previous slide

Next slide

Back to first slide

View graphic version