I would say, that EXISTS almost always performs better, because it can stop once the logical test is true, while COUNT walks through the whole resultset, even after the condition is met.

Frank

http://www.insidesql.de

http://www.familienzirkus.de