Aug 20 2021 03:04 AM
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?
Aug 20 2021 06:04 AM
I think it's because of this:
https://stackoverflow.com/questions/15826784/does-sql-server-caches-query-results