Home Forums SQL Server 2008 SQL Server 2008 Performance Tuning Count on table with million data too slow RE: Count on table with million data too slow

  • March 28, 2015 at 6:46 pm

    #1787130

    GilaMonster (3/18/2015)

    Koen Verbeeck (3/18/2015)

    you can create a new non-clustered index on ID and GPSTime.

    This, assuming there aren't any other indexes which we haven't been shown

    No, better to just add GPSTime to the existing non-clustered index on ID. It can still be a UNIQUE index as teh current one is, adding a key column makes no difference to that.

    edit: But as it apparently isn't the ID column after all, I haven't a clue

    Tom