Performance issue with ISNULL function

Is there any solution for this?

You already wrote the reason and solution; avoiding a function on a column in a WHERE clause:

select B.* 
from table B left join table A on B.Col3B = A.Col1 
where (A.IsActive = 1 OR A.IsActive IS NULL)

---

Olaf Helper

Blog Xing