I am using full text indexing for partial match and Today it started to be very slow when I use the following queries
It takes more than 1 min to return the results.
[Syn].[CustomerNamesSyn] AS Customer WITH(NOLOCK)
CONTAINS(Customer.CustomerName, ‘ ”any input string *” ’)
The full text index is set on CustomerName column
I was using same query for more than a year and has not experienced such slowness before.
What could have went wrong?