Hi,Please advise how i can optimise this query:insert @tblKeyword ( Keyword, IDSource, SourceID, KeywordTemplateID ) select dbo.ufn_ppcConvertToKeyword(pm.SYSProductName, default, default, default, default), 'PRD', min(p.SYSProductID), @DefaultPRDTemplateID from tblSYSProduct p join tblSYSProductName pm on p.SYSProductID = pm.SYSProductID and pm.UpdateDate>=@StartTime where p.SYSProductDisabledCode = 'E' and pm.LanguageCode = 'EN' and p.WebSiteID = @WebSiteID and not exists ( select * from tblKeyword k1 where k1.Keyword = dbo.ufn_ppcConvertToKeyword(pm.SYSProductName, default, default, default, default) and k1.WebSiteID = @WebSiteID and k1.KeywordTemplateID = @DefaultPRDTemplateID ) and len(ltrim(rtrim(pm.SYSProductName))) > 0 group by dbo.ufn_ppcConvertToKeyword(pm.SYSProductName, default, default, default, default)
mk_garg