Noticed this old question the other day on Stack Overflow: Is a View faster than a simple Query?
The answer marked correct is a pretty confusing thesis, which has umpteen votes.
Somehow a question about views has become a rather long discussion about indexed views (which is a feature most people do not know about or use).
How would I go about fixing up this messy mess?
I already tried improving BradC's answer and upvoting it.