Confusion: "Manual", "Incremental", "Update"

Hi,
I'm using SQL Server 2005. What's difference between mechanisms of "Manual"
update and "Incremental" population? I also need some clarification about
"Update" type of population.
Thanks in advance,
Leila
There are three population types, full, incremental and change tracking.
Change Tracking can be continuous or on demand (Manual). When using the
Change Tracking - manual option you must run a ALTER FULLTEXT INDEX ON
TableName START UPDATE to process the tracked changes.
No matter what population method you try a full population will always be
done first. If you have a timestamp column on your table and have already
done an full population, an incremental population will be done.
Change tracking will track changes which occur to the columns you are
full-text indexing. They will be indexed near real time, or at scheduled
intervals using the alter command mentioned above.
A Full population will index every row on your table whenever it is run. An
incremental population will extract each row from your table and detect if
it has changed (it can't detect if the change occured to a column which you
are full-text indexing or not), and it will then compare it with its list to
see what has been deleted and then update the catalog with the
updated/deletions. Incremental populations take almost as long as
full-populations. Use incremental populations when small amounts of data
changes at discrete times. By small I mean around 40-80% or so. Use Full
when more than 90% occurs at any one time. Use change tracking everywhere
else. Your numbers may vary.
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
"Leila" <Leilas@.hotpop.com> wrote in message
news:%23fDNVdwRHHA.1200@.TK2MSFTNGP02.phx.gbl...
> Hi,
> I'm using SQL Server 2005. What's difference between mechanisms of
> "Manual" update and "Incremental" population? I also need some
> clarification about "Update" type of population.
> Thanks in advance,
> Leila
>
|||Thanks indeed Hilary!
1) Can I conclude that: When we use change tracking (manual), we must use
ALTER FULLTEXT INDEX by considering whether we have timestamp column or not.
If we have, then we must use START INCREMENTAL, unless START UPDTAE?
2) How the changes are tracked when we don't have timestamp column?
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:OYvp08wRHHA.4632@.TK2MSFTNGP04.phx.gbl...
> There are three population types, full, incremental and change tracking.
> Change Tracking can be continuous or on demand (Manual). When using the
> Change Tracking - manual option you must run a ALTER FULLTEXT INDEX ON
> TableName START UPDATE to process the tracked changes.
> No matter what population method you try a full population will always be
> done first. If you have a timestamp column on your table and have already
> done an full population, an incremental population will be done.
> Change tracking will track changes which occur to the columns you are
> full-text indexing. They will be indexed near real time, or at scheduled
> intervals using the alter command mentioned above.
> A Full population will index every row on your table whenever it is run.
> An incremental population will extract each row from your table and detect
> if it has changed (it can't detect if the change occured to a column which
> you are full-text indexing or not), and it will then compare it with its
> list to see what has been deleted and then update the catalog with the
> updated/deletions. Incremental populations take almost as long as
> full-populations. Use incremental populations when small amounts of data
> changes at discrete times. By small I mean around 40-80% or so. Use Full
> when more than 90% occurs at any one time. Use change tracking everywhere
> else. Your numbers may vary.
> --
> 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
>
> "Leila" <Leilas@.hotpop.com> wrote in message
> news:%23fDNVdwRHHA.1200@.TK2MSFTNGP02.phx.gbl...
>