indexing method

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jeremy - 27 May 2008 16:45 GMT

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?

Reply to this Message

Hilary Cotter - 27 May 2008 21:41 GMT

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.

>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.
[quoted text clipped - 9 lines]
> updating. It also says there are performance hits. Where would I see
> these, and how siginificant?

Reply to this Message

Jeremy - 27 May 2008 23:08 GMT

Thanks

> You should use change tracking - I think that is what you mean by change
> log.
[quoted text clipped - 17 lines]
>> updating. It also says there are performance hits. Where would I see
>> these, and how siginificant?

Reply to this Message