• At first sight, I thought this was a question to check whether indexed views can have their own statistics. I did not know that, so I set out to research that, and I thought this was a great question.

    Than, I (luckily) doublechecked the question - and found that it is actually a question that tests my ability to read carefully, and to not fall victim to suggested information.

    The way the question is worded (with the starting words: "I set the options to support indexed views" (emmphasis mine) suggests that the view is indexed. It is very easy to overlook the fact that no index is created, hence it is a normal, unindexed view.

    Ron has already submitted a lot of questions, and I have never seen him intentionally try to trick people, so I am sure that it was not his intention to make this a trick question either.


    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/