Forum Discussion
VarQwerty
Aug 20, 2021Copper Contributor
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
Sort By
- alescanBrass Contributor
I think it's because of this:
https://stackoverflow.com/questions/15826784/does-sql-server-caches-query-results