Full-text retrieval technology SQL server

Before full-text retrieval, the personal homepage can only perform a fuzzy query (like '% * %') on the Fs_Title field. If you perform a fuzzy query on the content, the speed is extremely slow, sometimes an error may be reported. I am free now. I have finished the query and tested it.
Try to retrieve 10 thousand records in less than two seconds. ENJOY ~~
Copy codeThe Code is as follows:
Use LuanLuanDB
Exec sp_fulltext_database 'enable'
Exec sp_fulltext_catalog 'artilefulltext', 'create', 'e: \ searchpage'
Exec sp_fulltext_table 'tarticle', 'create', 'artilefulltext', 'pk _ tarticle'
Exec sp_fulltext_column 'tarticle', 'fs _ title', 'add'
Exec sp_fulltext_column 'tarticle', 'fs _ content', 'add'
Exec sp_fulltext_table 'tarticle', 'start _ full'

Test code: select * from TArticle where Contains (*, '"& key &"') and Fi_IsShow = '1' order by Fi_ID DESC