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 (https://blog.sqlauthority.com)
3 Comments. Leave new
Hi Pinal,
1. Yes , 2. No
3. The table would use the index on the table, the view would use the index on the table unless one wants to force the optimizer to use the index on the view, Using the index on the table is much more efficient than using the index on the view.
I want example
Hi Friends,
Is DML statement possible in Function&View.
i am very confused of this question Some person tell YES and some say no.
but no buddy gives me Example.
Please give me Example if YES