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

  • July 20, 2010 at 7:55 am

    #1195536

    I had created an index the time column.. but since the query took long time to complete, i dropped that index...

    As mentioned the Exec plan shows 100% table scan