Hi,

I'd like to implement incremental population for a given table.

I don't understand if I need to use both "sp_fulltext_catalog" and =
"sp_fulltext_table" to accomplish this task. BOL is a bit nebulous in =
their explanation.

"sp_fulltext_catalog" has an @action value of "start_incremental"; =
"sp_fulltext_table" has an @action value of "start_change_tracking" and =
"start_background_updateindex"

Do I need to use all of these in a certain sequence?

Thanks.

--=20
--

No, the start_incremental will be sufficient.

keep in mind that the first time you do an incremental population a full =
population will be done. Also keep in mind that you need a timestamp =
column on your table otherwise a full population will always be done.

Also keep in mind that change tracking with update index in background =
will probably offer the best performance for you as with it only the new =
or modified rows are indexed. With both a full and incremental =
population every row is extracted from the tables you are FTI'ing.

--=20
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

[quoted text, click to view]
Hi,

I'd like to implement incremental population for a given table.

I don't understand if I need to use both "sp_fulltext_catalog" and =
"sp_fulltext_table" to accomplish this task. BOL is a bit nebulous in =
their explanation.

"sp_fulltext_catalog" has an @action value of "start_incremental"; =
"sp_fulltext_table" has an @action value of "start_change_tracking" and =
"start_background_updateindex"

Do I need to use all of these in a certain sequence?

Thanks.

--=20
--