Full Text index on multiple tables | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Full Text index on multiple tables

Can anyone tell me how to set up Full Text index on multiple tables with joins. Eg. Product
————-
ProductID
PartNumber
ManufacturerID Manufacturer
————-
ManufacturerID
ManufacturerName I should be able to search on both Partnumber and ManufacturerName of that Product.
Ah, the joys of over-normalization!
http://www.databasejournal.com/features/mssql/article.php/1438211
http://www.sql-server-performance.com/ac_full_text_search.asp
http://msdn.microsoft.com/archive/default.asp?url=/archive/en-us/dnarntpro01/html/ntp0111.asp Fyi and HTH> Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
So it cannot be done huh…
Why do you need such index? You can put condition in where clause for each table involved.
Do you really need FULLTEXT on multiple columns, why not take linked servers help also in this case. Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>