Speed up SQL Server Fulltext Index through Text Duplication of Non-Indexed Columns
- by Alex
1) I have the text fields FirstName, LastName, and City. They are fulltext indexed.
2) I also have the FK int fields AuthorId and EditorId, not fulltext indexed.
A search on FirstName = 'abc' AND AuthorId = 1 will first search the entire fulltext index for 'abc', and then narrow the resultset for AuthorId = 1.
This is bad because it is a huge…