All geek questions in one place

Full-text indexing for multi-database view

Can MS SQL support full-text indexing for a view that joins (joins or merges) multiple databases?

+3
source share
2 answers

Yes, absolutely. Each index will be requested separately, and the results will be combined by the engine.

For example, if you have:

  • DatabaseA, TableA, FieldA Full Text Index
  • DatabaseB, TableB, FieldB with full text index

, , . SQL Server , .

, . !

+1

, .

.

, Left/Right Unions.

, , .

0

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

More articles:


All Articles