Hi,

I have one doubts in using the IN operator in the subquery from the performance point of view. If I use the IN operator, somebody is saying that it should not be used, instead exists operator can be used.

Please let me know if any body knows that why we should not use IN operator

Thanks in advance

Regards,
Saravanan.P