sql server - Limiting SQL Full Text Indexing

Question

I was wondering if there was a way to limit my Full Text Indexing to, in laymen terms, include a WHERE clause.

CREATE FULLTEXT INDEX ON [Order] KEY INDEX [PK_Order] ON [ft_Order] WITH CHANGE_TRACKING AUTO

ALTER FULLTEXT INDEX ON [Order] ADD ([Email])
ALTER FULLTEXT INDEX ON [Order] ADD ([Address])

ALTER FULLTEXT INDEX ON [Order] ENABLE

The [Order] table also has a column for [IsPending], and I was trying to see if it was possible to only index when the [IsPending] column is a certain criteria. Other potentials solutions are an indexed view, but I was hoping there was another clever solution that I have not been able to successfully find.

Thanks in advance.

question from:https://stackoverflow.com/questions/65904490/limiting-sql-full-text-indexing

Answer 1

Waitting for answers