- You can improve the results of basic text search queries by choosing a text analyzer that best fits your data and query needs. A text analyzer determines how the text is indexed. The snowball analyzer indexes word stems. The CJK analyzer processes Chinese, Japanese, and Korean text. The Soundex analyzer indexes words by sound. Other analyzers are variations of these analyzers and the standard analyzer. You can also create your own analyzer.
- You can create a thesaurus of synonyms to use during indexing.
- You can specify different stopwords for each column being indexed instead of using the same stopwords for all indexed columns.
- You can query each column in a composite index individually.
- You can increase the maximum number of query results.
See the What's New for links to each of these features.
Here are a couple of examples:
The following example creates a bts index on two XML fields and uses a different analyzer for each field:
CREATE INDEX boats_bts
ON boats(xml_data bts_lvarchar_ops)
The following example creates stopword list of am, be, and are for all fields except the fields author and title, which have their own stopwords, and the field edition, which does not have any stopwords.
CREATE INDEX books_bts ON books(book_data bts_lvarchar_ops)