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 26, 2015 at 11:31 pm

    #1786741

    try this

    select count(id)

    from tablename WITH(nolock)

    where gpstime between A and B

    and id=123;