Thanks guys for your help. Union of cause does fine, so other options I have tried, and the plan looks like did not show anything abnormal. The question I...

Yes, I am thinking the same: it might correlates each row of the large table with “OR” part of the small table (subquery ) as if I have...