HI ,

you can try indexing and some tweeking in the query for object A to avoid spooling for loop join,

for better help please provide actual plan.