General information
Forum:
Microsoft SQL Server
Does this apply if the data in the full-text index table is read-only and the data has not changed since the first full population?
Thanks,
Mike
>Full-Text indexes are not dynamically maintained like SQL Server's native indexes are. You must periodically refresh them. Manually refreshing them and try your query again.
>
>You'll probably find that you need to create a job to periodically refresh the indexes. The SEM can help you with this.
>
>-Mike
>
>
>>Hi,
>>
>>Here is the query I am using for my full-text searching:
>>
>>SELECT COUNT(*) as hits
>>FROM links a, links_details b INNER JOIN
>>CONTAINSTABLE (links_details, *, @strSearch, 200 ) c
>>ON b.link_id = c.[KEY]
>>WHERE (a.link_id=b.link_id) AND (c.rank>70)
>>OPTION (KEEPFIXED PLAN)
>>
>>
>>If @strSearch = "small business" the query returns all the results in the table that match.
>>
>>However, if @strSearch = "small business opportunities" the query returns no results even though there are records in the full-text indexed column that contain this exact phrase, in that exact order.
>>
>>Is there anything I can or need to do to the query to make it work properly?
>>
>>TIA,
>>Mike
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only