Post reply

Composite non-clustered index.

  • March 16, 2012 at 1:30 am

    #270115

    Hi Team,

    In our sinario ExchangeTable have 24 columns in this one we have create one clustered index ExchangeID

    Remaining 23 colums we have create composite non-clusterd index.

    the prob is composite non-clustered index automatically include Exchange ID or not

  • March 16, 2012 at 2:15 am

    #1460352

    Yes, they will.

    That said, indexing every column of the table is a poor strategy. It's unlikely to produce indexes that are useful to the queries and very likely to create lots of indexes that are never used.

    See http://sqlinthewild.co.za/index.php/2011/11/11/sql-university-advanced-indexing-indexing-strategies/

    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

  • March 16, 2012 at 2:38 am

    #1460360

    Thanks for your conformation.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply