It seems that I’ve missed a basic concept concerning SQL Server query optimization. The query optimizer can choose to use the indexed view, even when the indexed view isn’t referenced in the original select statement. I didn’t know that and was quite surprised when I read about it this morning.

But now that I know, the example makes perfect sense.