Forum Discussion

VarQwerty's avatar
VarQwerty
Copper Contributor
Aug 20, 2021

Full Text Search

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

  • alescan's avatar
    alescan
    Brass Contributor

    VarQwerty 

    I think it's because of this:

    https://stackoverflow.com/questions/15826784/does-sql-server-caches-query-results

Resources