Correlated Sub-Queries: First Row/Semi-Join
1) sysadm.ps_jrnl_ln: INDEX PATH
(1) Index Keys: process_instance business_unit
Lower Index Filter: (ps_jrnl_ln.business_unit = 'ABC' AND ps_jrnl_ln.process_instance = 5960 )
2) informix.a: INDEX PATH (First Row)
Filters: (informix.a.range_to_06 >= ps_jrnl_ln.account AND a.tree_effdt = <subquery> )
(1) Index Keys: setid chartfield combination range_from_06 range_to_06
Lower Index Filter: (a.setid = 'ABC' AND (a.combination = 'OVERHEAD' AND a.chartfield = 'ACCOUNT' ) )
a.range_from_06 <= ps_jrnl_ln.account
NESTED LOOP JOIN (Semi Join)