• Execution plan

    Cost

    select 0%

    Parallelism(Gather Streams) 0%

    Sort(Distinct Sort) 0%

    Parallelism(Repartition Streams) 0%

    Hash Match(Partial Aggregate) 3%

    Compute Scalar 0%

    Clustered Index Scan[tblGLJnlEntrySum].tblGLJnlEntrySum_PK 97%

    Inaddition i am getting message like below

    /*

    Missing Index Details

    The Query Processor estimates that implementing the following index could improve the query cost by 97.4146%.

    */

    /*

    CREATE NONCLUSTERED INDEX [<Name of Missing Index, sysname,>]

    ON [dbo].[tblGLJnlEntrySum] ([DivCode])

    INCLUDE ([glPeriodYear],[glPeriodMonth])

    */

    so is that means that i have to create suc index mentioned above?