full text indexing/catalogues

[tinapa]

hi guys,

i just want to ask for your advice.

i have a sql server database with more than 30 tables and i want to implement a full-text indexing on it. there's around 15 main tables, around 10 link tables and 10 lookup tables. some tables share the same lookup tables. this database is around 70MB in size. my questions are:

1. is it a good idea to have different catalogues for each related tables? or 1 catalogue for all the tables?

2. will the full-text indexing affect the performance of the win2003 server? if the updating of the indexing is done everyday.

3. there were times in the past that i need to modify the structure of a table in the database. will this affect the indexing? will it still work if i need to modify a table again?

this is the reason why i asked the 1st question above so that if i need to modify a table again, the indexing will not affect the whole lot.

thanks guys for any inputs.

 

[tinapa]

additional question guys.

4. is it a good idea to just have 1 catalog per table? can i still search the joined tables even if each table has its own catalog? will it affect the performance/speed of search?

thanks

 

[tinapa]

any ideas guys?