Post reply

Full Text Search - where are system stoplists stored?

  • August 22, 2011 at 9:30 am

    #1371484

    skrilla99 (8/22/2011)

    Thomas Abraham (8/22/2011)

    Thanks for the question!

    I'm curious about the terminology though. The previously used "noise words" did a good job at conveying the meaning of what was being represented. Seems like "stopwords" is less clear as to purpose. Can anyone enlighten me as to why this terminology was chosen?

    I totally agree on the term... Noise words makes sense to me, stop words not so much...

    -Dan

    Ditto. Terminology is a bit confusing. I guess it was used to mean "stop creating the full text index when you hit these words" of course the index creation does not actually stop but instead just discards those words that exist in the stoplist. I like noisewords better because I liken it to cleaning out the noise from a recording. For instance if you were transferring an LP to CD you would want to remove as much of the noise from the recording as possible (pops, fuzziness, scratches). This would result in a more optimized recording just as a full text index is more optimized for searches when the noisewords are removed.

  • August 22, 2011 at 11:06 am

    #1371584

    nice question to ring in the new week - cheers! 🙂

  • August 22, 2011 at 11:40 am

    #1371610

    thanks for the question.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • August 22, 2011 at 11:34 pm

    #1371767

    Nice question, thanks.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • August 23, 2011 at 3:34 am

    #1371829

    Good question, thanks.

    M&M

Viewing 5 posts - 16 through 19 (of 19 total)

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