SQL Server Performance

How Non-Clustered Index Works ?

Discussion in 'Performance Tuning for DBAs' started by veereshnashi, Mar 1, 2006.

  1. veereshnashi New Member

    Recently I went for an interview, There they asked what is the difference between Clustered And Non-Clustered Index and How they work. I could able to explain What is the difference between them and how clustered Index. I stuck while explaining how exactly non-clustered Index works with an example on a employee id . <br />Please Somebody explain me how exactly non-clustered Index works with an exactly and also how indexing works if we create it on a view whcih involves more than two tables. ?<br />[<img src='/community/emoticons/emotion-11.gif' alt='8)' />]<br /><br />You Store, I Manage
  2. FrankKalis Moderator

  3. satya Moderator

    Also refer to the book Inside SQL server written by Kalen Delaney and refer tohttp://www.sqlskills.com for refernce on indexes.

    Satya SKJ
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  4. veereshnashi New Member

    Thanks for the Links.


    You Store, I Manage

Share This Page