Hi,
Can one Full-Text Catalog apply to more than one tables?
e.g. I need Full-Text Catalog in Northwind that needs to apply to
Customers and Categories table, should I create one Catalog for two tables or
one catelog for each table?
what is the difference?
Thanks a lot
Ed
Hi Ed,
Yes, a FT Catalog can have more than one table in it, but the reverse (one
table in more than one FT Catalog) is not true.
For the Northwind example, you can do either, but for a better explanation
on the issues see, the last paragraph in the SQL Server 2000 BOL title
"Full-text Search Recommendations".
Regards,
John
"Ed" <Ed@.discussions.microsoft.com> wrote in message
news:FA3CB9AB-2B76-498C-A9EC-15B76D2F578A@.microsoft.com...
> Hi,
> Can one Full-Text Catalog apply to more than one tables?
> e.g. I need Full-Text Catalog in Northwind that needs to apply to
> Customers and Categories table, should I create one Catalog for two tables
or
> one catelog for each table?
> what is the difference?
> Thanks a lot
> Ed
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment