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


  • 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

    Friday, January 04, 2013 10:43 PM