Robert, I will check this out sometime by coding some examples and checking the query plan, but must admit I am dubious. I can see that your assertion would be right IF the subquery...
Probably Brendt is right in this case. However, I am dubious whether your explanation and assumptions can be generalized quite so easily. It seems to me that whether IN or EXISTS...