Full-Text Indexing - General Newbie Questions
Posted on 2006-11-06
I'm new to full-text indexing and just have some general questions:
1) When should I create new index catalogues? If I had a message board with 1million messages to search and a second message board identical to the first one but for a different kind of postings, should they be in different catalogues?
2) I used the Full-Text Indexing Wizard and on one of the screens, I selected to "Track Changes to the Table and Views" automatically--is this a good option?
3) I did not define New Table Schedule or New Catalogue Schedule in the following screen--should I? For one or both? What is the difference between the two?
I am asking these questions here to try sort out and learn some of the simpler essential things in small chunks first before continuing to readup on MSDN.