Home Forums Article Discussions Article Discussions by Author Discuss content posted by Shiva N Index Behaviour RE: Index Behaviour

  • November 23, 2014 at 3:06 am

    #1760376

    Hi,

    I think the non clustred index it used in all the five queries.

    I have tested the example on SQL Server 2008 R2 and I have display the execution plan, that show sql server uses the non clustred index for the five queries.

    Thanks