Actually we went back to the original topic which was my disagreement with the following statement:

"In this case SQL Server will still have to join all the tables in the...

Ok, I admit there is more to it than meets the eye and Jeff is right with the samples he provides. The reason that you are seeing that behavior in...

I posted a reply ONLY to clear up a comment that was made in the original article, and mainly because most people actually consider the comment in the article as...

Like you, I did not like views for many years until I really knew what was going on under the hood and confirmed the the benefits for which they'r inteded....

There is a general misconception of the following statement that you make.

"In this case SQL Server will still have to join all the tables in the view to return...