Oracle 5.0, Справочное руководство

Страница: 473 / 3232

Server System Variables
453
Min
Value
1
The minimum length of the word to be included in a
FULLTEXT
index.
Note
FULLTEXT
indexes must be rebuilt after changing this variable. Use
REPAIR
TABLE tbl_name QUICK
.
•
ft_query_expansion_limit
[453]
Command-Line Format
--ft_query_expansion_limit=#
Option-File Format
ft_query_expansion_limit
Option Sets Variable Yes,
ft_query_expansion_limit
[453]
Variable Name
ft_query_expansion_limit
Variable Scope Global
Dynamic Variable No
Permitted Values
Type
numeric
Default
20
Range
0 .. 1000
The number of top matches to use for full-text searches performed using
WITH QUERY EXPANSION
.
•
ft_stopword_file
[453]
Command-Line Format
--ft_stopword_file=file_name
Option-File Format
ft_stopword_file=file_name
Option Sets Variable Yes,
ft_stopword_file
[453]
Variable Name
ft_stopword_file
Variable Scope Global
Dynamic Variable No
Permitted Values
Type
file name
The file from which to read the list of stopwords for full-text searches. The server looks for the file in
the data directory unless an absolute path name is given to specify a different directory. All the words
from the file are used; comments are not honored. By default, a built-in list of stopwords is used (as
defined in the
myisam/ft_static.c
file). Setting this variable to the empty string (
''
) disables
stopword filtering. See also Section 12.9.4, “Full-Text Stopwords” .
Note
FULLTEXT
indexes must be rebuilt after changing this variable or the contents
of the stopword file. Use
REPAIR TABLE tbl_name QUICK
.
•
group_concat_max_len
[453]
Command-Line Format
--group_concat_max_len=#
Option-File Format
group_concat_max_len
Option Sets Variable Yes,
group_concat_max_len
[453]