 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / Other Technologies / Full-Text Search / October 2007FT Catalog "optimise" or "populate" differences
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". Nick... 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.  SignatureRelevantNoise.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 > Hi, > [quoted text clipped - 6 lines] > > Nick... Thanks Hilary! > Population is where you get all the data from your tables and full-text > index it. [quoted text clipped - 3 lines] > this is forced every 50,000 rows. With change tracking you can get > significant fragmentation of your full-text indexes. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.