SELECT top 10 * from XYZ x

WHERE EXISTS (SELECT * FROM ABC a

WHERE a.Col2 = x.Col1

AND (Col3>date OR Col4>date OR Col5>date)

)

For this query (any version of it) to perform well the table ABC must have indexes on (Col3, Col2), (Col4, Col2), (Col5, Col2).