Group by slow at first time in sql server

[vivek484957]

Hi Sir,

I need your help, here is my query, it is slow first time

SELECT  COUNT(1) AS Results FROM ImportShipmentNew2013 
WHERE CONTAINS(ProductDescription, 'neem') --AND (@HSCode='' OR HSCode = @HSCode )
GROUP BY ForeignCountry

(69 row(s) affected)
Table 'Worktable'. Scan count 0, logical reads 0, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.
Table 'ImportShipment New2013'. Scan count 0, logical reads 721107, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.
Table 'Worktable'. Scan count 0, logical reads 0, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.

(1 row(s) affected)

Please suggest to index create to improve performance

[Rabbit]

create a full text index on your ProductDescript ion field and an index on your group by.