Post reply

Problem with Fulltext Search in SqlServer2005.

  • July 29, 2009 at 1:52 am

    #134630

    I have a problem with Fulltext Search in SqlServer2005.

    Normal query in sql : select * from employee where EmpName

    like '%test %' . It wil take 3 minutes.

    Simple Fulltext Search query: select * from employee where contains(EmpName,'"test*"')

    It wil return 50,000 records.

    Some times results came very fast (between 1 to 2 Minutes) some times it wil execute very slow(5 to 6) minutes.

  • July 29, 2009 at 2:47 am

    #1031512

    it depends on your results. try to rebuild your index and then try again. when you run query after closing your current session then it will take time. But after that it will run fast.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply