I should have been clearer, I meant the Wikipedia article. Ozar's article is much better. It doesn't make sweeping assumptions about the limitations of all que

I should have been clearer, I meant the Wikipedia article. Ozar's article is much better. It doesn't make sweeping assumptions about the limitations of all query optimisers, or basic oversights in contrasting supposedly equivalent predicates.