Why would I create another directory next to the default?

I am new to Sql full-text server search. Why would I create another directory next to the default?

I really don’t understand exactly how the catalog organizes the full text indexes, I got the impression that it looks like a table layout. confirm it to me.

thanks

+4
source share
1 answer

It seems that adding a second Full Text directory to the same table is not possible. In SQL Server 2008R2, as soon as I added the directory, the button to add another is disabled:

enter image description here

You can add 2 matching columns to the same directory:

enter image description here

Additional tips for FTS:

Database Log - Setting Up Full-Text Search: Walkthrough

MSDN - SQL Server Best Practices - Full Text Search

+5
source

Source: https://habr.com/ru/post/1410855/


All Articles