• DBCC IND is an undocumented command that shows internal details of the index. It's not really useful to someone getting started.

    I would suggest you read the sections in books Online on indexes (or follow the below links for the MSDN articles) and then post if you have specific questions.

    http://msdn.microsoft.com/en-us/library/ms189271(SQL.90).aspx - All about indexes

    http://msdn.microsoft.com/en-us/library/ms180978%28SQL.90%29.aspx - Table and index architecture

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass