• I liked the article as it brought into focus an element of the QO that I had not considered before.

    As an aside, I would like to point out that we commonly optimize exists / not exists sub-queries by using left outer joins. I've gotten into the habit now of not using 'exists' sub-queries due to the order of magnitude difference I've seen on some query executions.

    In any case, it is a good article.