I have what look like a very simple select query statement
with one sub query, but for some reason, it takes a long
time to come up (1+ min).
select empid, lname, fname from table1
where empid not in (select empid from table2 where HireDate = '01/1/2004')
order by empid.
How can I fix this query so that it would be better or more optimized?
** when I run the sub query on QA, it returns like 10 records, could that
be the cause?