Friday, January 04, 2013 10:43 PM
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
Monday, January 07, 2013 8:03 AMModerator
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.
TechNet Community Support