Considerations for Oracle Text Indexing

Use the CREATE INDEX statement to create an Oracle Text index. When you create an index and specify no parameter string, an index is created with default parameters. You can create either a CONTEXT, CTXCAT, or CTXRULE index.

This sections contains the following topics:

• Location of Text

• Document Formats and Filtering

• Bypassing Rows for Indexing

• Document Character Set

• Document Language

• Indexing Special Characters

• Case-Sensitive Indexing and Querying

• Document Services Procedures Performance and Forward Index

• Language-Specific Features

• About Entity Extraction and CTX_ENTITY

• Fuzzy Matching and Stemming

• Better Wildcard Query Performance

• Document Section Searching

• Stopwords and Stopthemes

• Index Performance

• Query Performance and Storage of Large Object (LOB) Columns

• Mixed Query Performance

You can also override the defaults and customize your index to suit your query application. The parameters and preference types you use to customize your index with CREATE INDEX fall into the following general categories.