I'm trying to speed-up a query and I was told to remove the NOT IN that 's in the query with something else like an OUTER JOIN.
select distinct tblA.*,tblB.type,
inner join sec on tblB.name=tblA.name
left join item_details on rtrim(parentid)=atd_unique_cust_key and appid='myApp'
where atd_unique_cust_key not in (
select distinct atd_unique_cust_key
inner join tblD on tblD.account=tblC.account);