Home Forums SQL Server 2005 SQL Server 2005 General Discussion Speeding up updates that use STDEV (standard deviation) RE: Speeding up updates that use STDEV (standard deviation)

  • March 3, 2009 at 9:17 am

    #952492

    I would love suggestions on how to improve my indexing!

    Right now I have 3 indexes on my table:

    1) A clustered PK index on a RowID column

    2) A non-clustered index on Date, then IDNumber which includes the StDev cols (and a few other cols not involved in this update)

    3) A non-clustered index on IDNumber then Date which includes the StDev cols (and a few other cols not involved in this update)

    Was that what you were looking for?

    Thanks!