SQL优化总结

--加字段限定和不加字段限定结果不一样

select *
from oe_order_lines_ALL ol
, oe_order_headers_ALL oh  
, hz_cust_accounts ca
where  ol.header_id=oh.header_id(+)  
and  oh.sold_to_org_id = ca.cust_account_id(+)    
and ca.account_number =2925