Full Text Indexes

• Sharon-328725

  SSC-Addicted

  Points: 424

  More actions

  January 12, 2012 at 3:26 am

  #251279

  How to search on more than one field with full-text indexes?

  I used that:

  SELECT TOP 10 * FROM TBL_TOC WHERE

  CONTAINS(TBL_TOC.TEXT, '"journal*"') AND CONTAINS(TBL_TOC.AUTH, '"Carl*"')

  But it's very slow...

  Thanks

  Sharon

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  January 12, 2012 at 3:52 am

  #1432330

  I think your issue is the same as your other post:

  http://www.sqlservercentral.com/Forums/FindPost1234607.aspx

  -- Gianluca Sartori

• Yuri55

  SSCrazy Eights

  Points: 8449

  More actions

  February 22, 2012 at 9:51 am

  #1450415

  Sharon-328725 (1/12/2012)

  ---

  How to search on more than one field with full-text indexes?

  I used that:

  SELECT TOP 10 * FROM TBL_TOC WHERE

  CONTAINS(TBL_TOC.TEXT, '"journal*"') AND CONTAINS(TBL_TOC.AUTH, '"Carl*"')

  But it's very slow...

  Thanks

  Sharon

  Actually you can use: CONTAINS(TBL_TOC.TEXT, '"journal*"' AND '"Carl*"') syntax.

  But if your table is big be ready to wait for a long time.

  BTW, Sql Server 2008 can be your solution as FTS there is better (especially if your WHERE clause

  comprises extra, not FTS conditions)