SQL Server 2008 Full Index - performance improvements

• isuckatsql

  SSChampion

  Points: 10381

  More actions

  March 5, 2009 at 1:34 pm

  #207232

  I have lots of text files that are stored in a sql server 2008 db.

  I am currently using a sql query that uses (like '%xyz%') as part of my search query.

  Is 'contains' more efficient than 'like' ?

  Can you setup a frequently used word index as part of sql 2008 full text indexing ?

  Obviously i cant index every field !

  It is taking about 10 minutes to search 27 GB of text files 🙁

• Jerry Hung

  SSChampion

  Points: 12968

  More actions

  March 6, 2009 at 1:43 pm

  #955248

  If you are really searching for terms, FULL-TEXT will be faster

  and it will return results right away, with a rank (but full-text has its cons)

  You can create a full-text catalog, pick a table, and the columns used

  Not sure what you meant by "frequently used word index"

  SQLServerNewbieMCITP: Database Administrator SQL Server 2005