Full-text index performance optimization

The full-text index performance of SQL Server has never been very good. I heard from my colleagues today and found a skill. I went back and tried it. I found that it can significantly improve the full-text index performance, which can generally be improved.2x +

Original SQL statement:

Select * FromTable1WhereContants (*,'Test')

Optimized SQL statement:

Select * From Table1 where contains (content, title), 'test ')

The difference between the two SQL statements is whether or not the column names after contanis are specified. After testing, specifying the full-text index column can indeed greatly improve the full-text index performance of SQL Server.