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.
| Author |
Topic |
|
ramon6969
Starting Member
11 Posts |
 Posted - 2009-03-18 : 09:34:52
|
| 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.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 guys for any inputs. |
|
|
|
|
|
sql server / indexing / catalogs