Subject Count in Join slowly when using 'in'
Author sibo_oskam
Hi all,

I want to do something like:
Select Count(*) From Employee E Inner Join Employer R On
(E.EmployerId=R.Id) Where R.Id In (10,20,30)

This is very slow; When I do Where R.Id=10 it is very fast. What is
wrong with my query?

Thanks a lot,
Sibo