Hi,

In SQL 2005 does anyone know what the difference between a full text
catalogue "optimize" and a "populate" is? In 2000 I think there was only
populate.

It seems you can't schedule a normal "populate" in 2005 - only an
"optimise".

Population is where you get all the data from your tables and full-text
index it.

Optimization is where you consolidate the numerous indexes that may form as
the result of an indexing operation for a table into one index. Normally
this is forced every 50,000 rows. With change tracking you can get
significant fragmentation of your full-text indexes.

--
RelevantNoise.com - dedicated to mining blogs for business intelligence.

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]

Thanks Hilary!

[quoted text, click to view]