Home Forums SQL Server 2008 SQL Server Newbies Secondary indexes in SQL Server. RE: Secondary indexes in SQL Server.

  • January 21, 2013 at 5:10 am

    #1579198

    OTF (1/21/2013)

    I can only imagine a writer using the term "secondary indexes" to refer to any indexes other than one on a Primary Key?

    That would be an incorrect term for them. The only 'secondary' indexes in SQL are secondary XML indexes. Indexes other than the primary key are just clustered/nonclustered indexes.

    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