I am using a SQL Server 2008 R2 DB with FTS enabled on it. I applied an FTS index on a table. The table is frequently updated (I mean the CUD operations). Keeping this in mind, I came up with a strategy for updating the above index:
- I run an update population of the index when any delete occurs on that table
- I run an update population of the index once an hour to track the newly inserted texts
I would be grateful for any constructive criticism of my ideas. Should any additional details be necessary, I will provide them.
Thanks in advance