Full Text Search

Copper 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