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 (http://blog.SQLAuthority.com)

3 thoughts on “SQLAuthority News – Last Day to Participate in my Questions at SQL Quiz

  1. 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.

    Like

  2. 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

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s