Overview of Full Text Stop Words（MSSQL全文索引的干扰词概括）MSSQL 全文索引的最小单词长度...

什么叫做Stop words（干扰词）呢

这些词不用于全文索引。这些词一般都是比较常用的词，一般不用于搜索，如果用于搜索，则有很多返回结果。比如'a','the'这些词。Stop words不用于索引，所以不能被搜索到。 

经过测试MSSQL 全文索引的最小单词的长度为2，最大的单词长度为30。也就是为如果长度为1（如'e'）的是不能被搜索到的。但('ee')是可以被搜索到的。

Stop words（干扰词）的位置:

这些Stop words根据不同的语言分别存放在不同的文件中。（比如noiseENU.txt, noiseCHS.txt）

用select @@language来查看当前语言

如果你是默认安装SQL的话，目录为：

 C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\FTData

修改Stop words（干扰词）步骤：

1. disable change tracking 

 ALTER FULLTEXT INDEX ON kbcontents SET CHANGE_TRACKING OFF

2. Stop full-text catalog population. 

 ALTER FULLTEXT INDEX ON KBContents STOP POPULATION

3 修改 noiseENU.txt, noiseCHS.txt 文件(最好先备份)

4. Repopulate the full-text catalogs. 
  ALTER FULLTEXT INDEX ON table_name SET CHANGE_TRACKING AUTO

默认英文干扰词列表 (“noiseENG.txt”):

1	before	these	on	him
2	being	they	only	himself
3	between	this	or	his
4	both	those	other	how
5	but	through	our	if
6	by	to	out	in
7	came	too	over	into
8	can	under	re	is
9	come	up	said	it
0	could	use	same	its
about	did	very	see	just
after	do	want	should	like
all	does	was	since	make
also	each	way	so	many
an	else	we	some	me
and	for	well	still	might
another	from	were	such	more
any	get	what	take	most
are	got	when	than	much
as	has	where	that	must
at	had	which	the	my
be	he	while	their	never
$	have	who	them	no
because	her	will	then	now
been	here	with	there	of
would	you	your
a b c d e f g h i j k l m n o p q r s t u v w x y z

相关搜索： change fulltext index minmum length MSSQL,  全文索引的单词长度受限

 

转载于:https://www.cnblogs.com/webfpc/archive/2009/10/24/1588999.html