Subject | Count in Join slowly when using 'in' |
---|---|
Author | sibo_oskam |
Post date | 2005-02-14T13:21:55Z |
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
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