Beginner's performance question about Full-Text Index searches in SQL 2008

Question

I've just implemented my first full text index.  This includes a couple of varchar fields and a varbinary(max) field in which we anticipate many Word DOCs and DOCXs.

I have absolutely zero experience in this area.

So far so good.  I'm able to search within a sample doc.  

Typical query.  Select * from table1 where contains (*, 'search string')

I was just wondering if I can assume that full text searches, like conventional ones, would be sped up if you included a date range.

For example: Select * from table1 where contains (*, 'search string') and Table1.CreateDate > @paramDate1

Answer 1

Hi B.Chernick,

That's right, we can use logical operation between search conditions. The CONTAINS predicate and CONTAINSTABLE function use the same search conditions. Both support combining several search terms by using Boolean operators—AND, OR, AND NOT—to perform logical operations.

Use this condition can speed up the search performance as long as you know what condition should be specified.

Reference:

http://msdn.microsoft.com/en-us/library/ms142583.aspx#Using_Boolean_Operators

TechNet Subscriber Support

If you are TechNet Subscription user and have any feedback on our support quality, please send your feedback here.

---

Iric Wen
TechNet Community Support