SQL problem
Hi.
I have problem with update like this ex.
UPDATE Table1 SET Check='Y'
WHERE Table1.ID NOT IN (SELECT Table1ID FROM Table2)
Problem is very long time of execution when Table2 has milions of records.
Any idea how to solve this?
Hi.
I have problem with update like this ex.
UPDATE Table1 SET Check='Y'
WHERE Table1.ID NOT IN (SELECT Table1ID FROM Table2)
Problem is very long time of execution when Table2 has milions of records.
Any idea how to solve this?