My very good friend, Jacob Sebastian, is running a month-long SQL Quiz Series where the best-of-the-best experts from around the globe would be the quiz masters. They will ask one question every day, and users are expected to answer them correctly. The winning prizes include cool gadgets like iPAD, Kindle and many more.
I am one of the quiz masters, and my question is published here: The View, The Table and The Clustered Index Confusion. I have asked there three questions.
Q1. Does the table use an index created on itself?
Q2. Does the view use an index created on itself?
Q3. Do both queries use the same index? If yes, why? If no, why not?
Today is the last day to participate in the SQL Quiz.
I have already written the answer as a hint over here: SQL SERVER – Indexed View always Use Index on Index
Additionally, if above problem interest you, I suggest you read my article series on limitations of the view SQL SERVER – The Limitations of the Views – Eleven and more…
Reference: Pinal Dave (http://blog.SQLAuthority.com)