Information générale
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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement