prakashs43, I'm curious. try set timing on, and run the query both ways a let me know what the time is for each method. It is possible that WHERE EXISTS isn't always best.