SQL Server Full Text Indexing 1

[tinapa]

hi guys,

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?

thnx for any ideas.

 

[mrdenny]

I prefer to have one catalog per table, so that I can move them to separate disks if I need to.

You can still join the tables together, it shouldn't impact performance as each table will require a separate call to the indexing service.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2008 Implementation and Maintenance / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Admin (SQL 2005/2008) / Database Dev (SQL 2005)

My Blog

 

[tinapa]

thanks very much mrdenny. that's a great help.

have a nice day!

 

[mrdenny]

no problem.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2008 Implementation and Maintenance / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Admin (SQL 2005/2008) / Database Dev (SQL 2005)

My Blog