Considerations for Oracle Text Indexing

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

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

This section contains the following topics:

• Location of Text

• Supported Column Types

• Storing Text in the Text Table

• Storing File Path Names

• Storing URLs

• Storing Associated Document Information

• Format and Character Set Columns

• Supported Document Formats

• Summary of DATASTORE Types

• Document Formats and Filtering

• Bypass Rows

• Document Character Set