Table 2-7 shows the settings for different text configuration objects and how the settings impact what is indexed and how a full text query string is interpreted. All the examples use the string 'I'm not sure I understand'.
Configuration settings |
Terms that are indexed |
Query interpretation |
|---|---|---|
TERM BREAKER: GENERIC MINIMUM TERM LENGTH: 1 MAXIMUM TERM LENGTH: 20 STOPLIST: '' |
I m not sure I understand |
'("I m" AND not sure) AND I AND understand'
|
TERM BREAKER: GENERIC MINIMUM TERM LENGTH: 2 MAXIMUM TERM LENGTH: 20 STOPLIST: 'not and' |
sure understand |
'understand' |
TERM BREAKER: GENERIC MINIMUM TERM LENGTH: 1 MAXIMUM TERM LENGTH: 20 STOPLIST: 'not and' |
I m sure I understand |
'"I m" AND sure AND I AND understand' |
