Below is the sample query.. The final output is 8K rows.. In explain plan cost shows 292.. And total query execution time is 35 secs. how will re-write the below query with better performance?
select acctid, userfirstname, userlastname, assettype,
(select max(riskscore) from risk r where r.rid = TA.rid) as riskscore
from TA inner join TB on TA.acctid = TB.acctid inner join TC on TC.key = TB.key;