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?