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
    veereshnashi, Mar 1, 2006
    #2

  2. FrankKalis Moderator

    Broad question you've asked. Check out BOL and sources like:
    http://support.microsoft.com/default.aspx?scid=kb;EN-US;820209
    http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ss2kidbp.mspx
    http://support.microsoft.com/default.aspx?scid=kb;EN-US;325024
    http://support.microsoft.com/default.aspx?scid=kb;EN-US;814324

    --
    Frank Kalis
    Microsoft SQL Server MVP
    http://www.insidesql.de
    Heute schon gebloggt?http://www.insidesql.de/blogs
    Ich unterst�tze PASS Deutschland e.V. http://www.sqlpass.de)
    FrankKalis, Mar 1, 2006
    #2

  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.
    satya, Mar 2, 2006
    #2

  4. veereshnashi New Member

    Thanks for the Links.


    You Store, I Manage
    veereshnashi, Mar 2, 2006
    #2

Share This Page