I need some advice/ideas.
I have a table containing job announcements approx. 250,000 records
In another table is 6000 keywords/sentences from applicant cv's historically regarded by the government as typical
I want to find job announcements where the text contains one or more of the keywords
I have been doing this, using full-text-search, but firstly, the variable, can´t hold all keywords and secondly it is very slow
DECLARE @Keywords NVARCHAR(MAX) SELECT @Keywords = STUFF((SELECT '|' + Word FROM dbo.Keywords FOR XML PATH('') ), 1, 1, '') SELECT * FROM dbo.Notes WHERE CONTAINS(Note, @Keywords)
Do you have any bright suggestions of how to solve this challenge ?