Why do SQL FullText queries slow down when you OR? Why do SQL FullText queries slow down when you OR? sql sql

Why do SQL FullText queries slow down when you OR?


Does changing to using ContainsTable help?

It did here Adding more OR searches with CONTAINS Brings Query to Crawl

And the same answerer (Joe Stefanelli) managed to bring about a similar improvement by changing FREETEXT predicates combined with OR to a FREETEXTTABLE here SQL Server full text query across multiple tables - why so slow?


I'd take a look at the execution plan for each of those. I'm guessing you will learn quite a bit from that.

Here is a decent link that will show you how to display the execution plan as well as some tips on interpreting it.