SELECT order_line.cust_company_id cust_company_id, order_line.line_no line_no, order_line.order_id order_id, 
order_line.request_id request_id, order_line.ldmnd_stat_id ldmnd_stat_id, order_line.open_date open_date, 
order_line.creation_datetime creation_datetime, order_line.priority priority, service_call.sa_person_id 
sa_person_id, order_stat.descr order_stat_descr, order_line.descr descr, 
address.address_id address_id, order_line.order_stat_uniq_id order_stat_uniq_id, order_stat.order_type_id 
order_stat_order_type_id  FROM order_line  LEFT OUTER JOIN service_call 
ON order_line.order_id=service_call.order_id LEFT OUTER JOIN order_stat ON 
(order_stat.order_type_id = 'const_param') AND  
order_line.order_stat_uniq_id=order_stat.order_stat_uniq_id AND 
order_line.order_type_id=order_stat.order_type_id LEFT OUTER JOIN address 
ON order_line.ship_to_address_id=address.address_id WHERE 
( order_line.node_id in ('') or  1 = 1  or order_line.node_id IS NULL) 
and (( 1  =  1 )) AND (order_line.order_type_id = 'const_param') AND 
(order_line.order_stat_uniq_id >=  100 ) AND (order_line.order_stat_uniq_id <  700 ) AND (( 1  =  1 ))

| --Hash Match(Right Outer Join, HASH:([address].[address_id])=([order_line].[ship_to_address_id]), 
 
RESIDUAL:([order_line].[ship_to_address_id]=[address].[address_id]))

| --Index Scan(OBJECT:([MyDB].[dbo].[address].[i_address_3]))
 

| --Hash Match(Right Outer Join, HASH:([order_stat].[order_stat_uniq_id])=([order_line].[order_stat_uniq_id]),
 
 RESIDUAL:([order_line].[order_type_id]='const_param'))

| --Clustered Index Seek(OBJECT:([MyDB].[dbo].[order_stat].[i_order_stat_1]), 
 
SEEK:([order_stat].[order_type_id]='const_param') ORDERED FORWARD)

| --Merge Join(Left Outer Join, MERGE:([order_line].[order_id])=([service_call].[order_id]), 
 
RESIDUAL:([order_line].[order_id]=[service_call].[order_id]))

| --Clustered Index Scan(OBJECT:([MyDB].[dbo].[order_line].[i_order_line_1]),  
 
WHERE:(([order_line].[order_stat_uniq_id]>= 100  AND [order_line].[order_stat_uniq_id]< 700 ) AND [order_line].[order_type_id]='const_param') 
ORDERED FORWARD)

|--Clustered Index Scan(OBJECT:([MyDB].[dbo].[service_call].[i_service_call_1]), ORDERED FORWARD)