Text Search Parameters

TextIndexMaxTokenLength

Controls the maximum size of a token in a text index. If the parameter is set to a value greater than 65000 characters, then the tokenizer truncates the token at 65000 characters.

You should avoid setting this parameter near 65000 (the maximum value). Doing so can result in a significant decrease in performance. For optimal performance, the parameter should be set to the maximum token value of your tokenizer.

Default Value: 128 characters

Example:

ALTER DATABASE database_name SET PARAMETER TextIndexMaxTokenLength=760;