Home Forums SQL Server 2008 SQL Server 2008 - General Massive slowdown in SELECT statement in Cursor from SQL 2000 to 2008 -- need help! RE: Massive slowdown in SELECT statement in Cursor from SQL 2000 to 2008 -- need help!

  • June 28, 2013 at 8:17 pm

    #1628467

    CREATE NONCLUSTERED INDEX [ix_new] ON [dbo].[SVSales]

    (

    [INum] ASC,

    [ProdNum] ASC

    )

    INCLUDE ( [FullAccNum])

    You might have to also include the OpenDate column if it's in SVSales.