SQLAuthority News – Last Day to Participate in my Questions at SQL Quiz

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)

SQL Index, SQL View
Previous Post
SQLAuthority News – Happy Deepavali and Happy News Year
Next Post
SQLAuthority News – Presenting at South East Asia SharePoint Conference – Oct 26, 27, 2010 – Singapore

Related Posts

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.

    Reply
  • Rakesh Gupta
    June 17, 2011 9:52 pm

    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

    Reply

Leave a Reply