Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
abhijeetdighe
Starting Member
24 Posts |
 Posted - 2009-09-17 : 02:14:36
|
| HiI am going to implement Full text index for the first time on one of my table in sql server 2000.Here are the steps I am going to follow:1. Initially I dont want index population and change tracking:CREATE fulltext INDEX ON myTable(heading,body) KEY INDEX PK_myTable ON myCatalog WITH CHANGE_TRACKING OFF, NO POPULATION;2. Then only for the first time after index creation, I will populate the index: ALTER FULLTEXT INDEX ON myTable START FULL POPULATION;This will execute only once.3. Then I will put the following in the sql job agent to run it on each day:sp_fulltext_table myTable 'Start_change_tracking' sp_fulltext_table myTable 'update_index' I will populate the index fully, only after its creationand after that index should be populated, only when scheduler runs and it should populate only changed rows. So, Is it the right way to implement full text search? |
|
|
|
|
|
Full text search