L' Eomot Inversé (10/14/2012)

---

Fun question.

I wonder how many people will fail to notice that although you've got everything ready to create the index you haven't actually done so, so the view is not indexed and can't have statistics.

Hugo Kornelis (10/15/2012)

---

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.