Home Forums SQL Server 2005 Administering SQL 2005 - SELECT query takes long time to retrieve RE: SQL 2005 - SELECT query takes long time to retrieve

  • January 9, 2013 at 11:29 pm

    #1575593

    Create a non clustered index on the field [Time] and then execute the query again.

    You should have a clustered index on the table also.