IgorMi (5/9/2013)
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
INdexes are there on the columns.. for less data it works fine but when data gets increased it takes more time to execute
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/