best practices for rebuilding full text search
- From: "Daniel Knöpfel" <d.kn@xxxxxx>
- Date: Wed, 2 May 2007 14:49:19 +0200
Hi
We are working with a sql server 2000 using full text search, which works
well so far. However, we are not sure which is the best way to ensure the
full text search is always working properly. As changes to the database
should be immediatly reflected in a search query, we have change tracking
enabled. But should we now rebuild the fulltext catalogue from time to time.
We are thinking about creating a job that runs every two months that
completly rebuilds the full text index.( exec sp_fulltext_catalog
N'OurFullTextCataloge', N'start_full' )
Would you suggest to do this or is having change-tracking enabled enough?
Thanks for any answer.
Greetings
Daniel
.
- Follow-Ups:
- Re: best practices for rebuilding full text search
- From: Hilary Cotter
- Re: best practices for rebuilding full text search
- Prev by Date: Re: tsschema.xml file is missing
- Next by Date: Re: tsschema.xml file is missing
- Previous by thread: tsschema.xml file is missing
- Next by thread: Re: best practices for rebuilding full text search
- Index(es):