Problem with Fulltext search in SqlServer2005

• vijaykumar-1135323

  SSC Journeyman

  Points: 92

  More actions

  July 29, 2009 at 3:16 am

  #212943

  I've created a FullTextCatalog on one of my Databases and added a full text index on one of my text columns.

  The first time I run a query against the data it takes roughly 40-45 seconds to return data. After that it blazes and runs in under a second. If I don't query it for 20-30 minutes, it will take 40-45 seconds again and then fly until the next break.

  Is there a configuration setting somewhere that I'm missing on this?

  Thanks,

  vijaykumar

• shamassaeedmr

  SSC-Addicted

  Points: 441

  More actions

  July 29, 2009 at 5:44 am

  #1031562

  I think it is normal behaviour. But set

  right click column index,

  go to options

  set auto update statistics to True

  and

  auto reindexes to ture

  this will help