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

  • does the table have a clustered index?

    you cannot do a covering index as the limit is 16 columns, I would deffinitally add a clustered and re-create a non clustered on time.