Hi,

What does its execution plan say? Are there any missing indexes? How big are the tables? Check the statistics on them.

You can replace the IN with EXISTS and NOT EXISTS.

Regards

IgorMi