Home Forums SQL Server 2012 SQL 2012 - General At what point do stoplists actually start improving performance ? RE: At what point do stoplists actually start improving performance ?

  • isuckatsql (9/18/2013)


    Since i don't know every new technology being developed, it is easier to remove the words that are unlikely to be searched.

    I don't think that this is a very good strategy. It can only lead to reduced benefit of the index. The single user that searches for "caramel" will not find that single résumé that includes that word. But you have only made a miniscule reduction of the index size.

    The performance should not really matter whether the stopwords are there or not. First, I don't think many of these 10000 words are frequent enough to reduce the size. But more importantly, an index is an index, which means that the size of the index does not matter much when you seek it, since you follow the B-tree (or whatever organisation a fulltext index has.)

    [font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]