Full Text Search

%3CLINGO-SUB%20id%3D%22lingo-sub-2668544%22%20slang%3D%22en-US%22%3EFull%20Text%20Search%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2668544%22%20slang%3D%22en-US%22%3E%3CP%3EI%20created%20a%20table%20with%20full%20text%20search.%20The%20first%20run%20script%3C%2FP%3E%3CPRE%3E%3CSPAN%20class%3D%22hljs-keyword%22%3ESelect%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22hljs-operator%22%3E*%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22hljs-keyword%22%3EFrom%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22hljs-keyword%22%3ETable%3C%2FSPAN%3E%0A%3CSPAN%20class%3D%22hljs-keyword%22%3Ewhere%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22hljs-keyword%22%3Econtains%3C%2FSPAN%3E%20(SearchPhrase%2C%20%3CSPAN%20class%3D%22hljs-string%22%3E'some%20phrase'%3C%2FSPAN%3E)%20%3C%2FPRE%3E%3CP%3Eis%20running%20slowly%2C%20but%20the%20next%20running%20is%20quickly.%20But%20when%20I%20run%20this%20script%20in%20the%20next%20day%20is%20again%20slow.%20Why%20so%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2669042%22%20slang%3D%22en-US%22%3ERe%3A%20Full%20Text%20Search%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2669042%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F833454%22%20target%3D%22_blank%22%3E%40VarQwerty%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20think%20it's%20because%20of%20this%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fstackoverflow.com%2Fquestions%2F15826784%2Fdoes-sql-server-caches-query-results%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehttps%3A%2F%2Fstackoverflow.com%2Fquestions%2F15826784%2Fdoes-sql-server-caches-query-results%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I created a table with full text search. The first run script

Select * From Table
where contains (SearchPhrase, 'some phrase') 

is running slowly, but the next running is quickly. But when I run this script in the next day is again slow. Why so?

1 Reply