Index: Preferences

Replace Preferences: Allows you to modify one or more of the preferences for the index.

Oracle interMedia Text uses the following preferences in creating the index:

Note: No Change means to keep the current setting for a preference.

Memory:

Set Memory Use must be between 1 megabyte and the value specified for max_index_memory in CTX_PARAMETERS. The default is the value specified for default_index_memory in CTX_PARAMETERS. If you are editing an index, memory size is the amount of memory used for the ALTER INDEX operation before flushing the index to disk.

Specifying a large amount memory improves indexing performance because there is less I/O, and it improves query performance and maintenance because there is less fragmentation. Specifying smaller amounts of memory increases disk I/O and index fragmentation, but might be useful if you want to track indexing progress or when runtime memory is scarce.

Buttons (Apply, Revert, Show SQL/Hide SQL)

See also: Main topics (outline)