indexing method

I have 2 tables that I would like to implement full text indexing on. I'm
just not sure if I should use incremental or change log updating.

Each table has 12 fields, I am only implementing the full text index on 1
column in each table. There will likely be around 4 - 8 inserts a minute on
each table, no updates. There will be sporadic searches on each table, and
there will be a scheduled job to purge records that are greater than x
number of days old.

The sql help mentions that incremental indexing handles
insert,update,deletes but it does not mention deletes in the change log
updating. It also says there are performance hits. Where would I see
these, and how siginificant?

You should use change tracking - I think that is what you mean by change
log.

The only time you should consider other population methods is when you have
very high numbers of inserts and then you might want to consider change
tracking with update manual, or use a full-or incremental population when
you are change large amounts of data at any one time.

"Jeremy" wrote in message

>I have 2 tables that I would like to implement full text indexing on. I'm
>just not sure if I should use incremental or change log updating.
>
> Each table has 12 fields, I am only implementing the full text index on 1
> column in each table. There will likely be around 4 - 8 inserts a minute
> on each table, no updates. There will be sporadic searches on each table,
> and there will be a scheduled job to purge records that are greater than x
> number of days old.
>
> The sql help mentions that incremental indexing handles
> insert,update,deletes but it does not mention deletes in the change log
> updating. It also says there are performance hits. Where would I see
> these, and how siginificant?
>