• shanmugaraj-307582 (11/10/2011)


    just look this site

    http://www.codeproject.com/KB/database/IndexIn2005.aspx

    I would suggest people don't read that. It has a number of mistakes in it. The main one being that the author of that describes the clustered index as a binary tree. SQL indexes are not binary trees, they are balanced trees. Since most of the article explains how a binary tree index works, it's mostly wrong.

    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