Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 full text index optimization

Author  Topic 

akpaga
Constraint Violating Yak Guru

331 Posts

Posted - 2008-04-03 : 12:41:50
my table has 23 million records with a full text index. The full text index catalog population is going on for ever and never seem to finish.. How to optimize the catalog population.

thanks

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-04-03 : 22:11:57
Put catalog on its own disk, run diff. population in shorter interval...
Go to Top of Page
   

- Advertisement -