Post reply

full text search question

  • September 17, 2010 at 10:03 am

    #148699

    Is there a difference in speed when doing full text search on multiple columns vs. one column?

    Thank you.

  • September 17, 2010 at 1:31 pm

    #1223297

    Though I have never personnally ran a speed test against a single column vs multiple column Full Text catalog, I do use both quite frequently and am always quite pleased with the results.

    The following article may be of interest to you

    http://msdn.microsoft.com/en-us/library/cc879244.aspx

    Chris Powell

    George: You're kidding.
    Elroy: Nope.
    George: Then lie to me and say you're kidding.

  • September 17, 2010 at 2:43 pm

    #1223324

    I have used it a lot as well, but so much of it is really hard to tell. you need to test it and check.

    Using 2005 FT does not use index statistics since the FT engine is outside of SQL. so if you look at the qry plan you will see an EST of like 10000 rows..

    2008 FT is inside of SQL and uses stats....in order order to come up with a better qry plan

    I am sure the more col you add the slower its going to be....it has to scan more pages of data...the ? is how much slower and again I am sure like most else in sql it Depends....like how big is the col and whats inside of the data, how many stop words so on and so forth at the end of the day I would just create 2 index and turn on statistics time one and check it out for your self

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

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