• The SQLPlan is attached and here is the index:

    USE [GLDemo]

    GO

    /****** Object: Index [BizTransIDX] Script Date: 11/12/2009 12:01:00 ******/

    CREATE NONCLUSTERED INDEX [BizTransIDX] ON [dbo].[GL]

    (

    [Company_No] ASC,

    [Year_For_Period] ASC,

    [Period] ASC,

    [Account_Number] ASC

    )

    INCLUDE ( [Journal_ID],

    [Amount],

    [Source],

    [Description],

    [Date_Created],

    [Date_Last_Modified],

    [Last_Maintained_By],

    [Currency_ID],

    [Foreign_Amount],

    [Trans_No],

    [Passcode],

    [Transaction_Date],

    [Units],

    [Transaction_Number],

    [StatusFlag]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]