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:
- Data Store
- Filter
- Lexer (cannot be changed to MULTI_LEXER for an existing index; see also Index Preference Columns)
- Word List
- Stop List (cannot be changed if you are in the process of adding stop words or
stop sections)
- Storage
- Section Group
Note: No Change means to keep the current setting for a preference.
Memory:
- Use Default Memory (12 M): Use the default amount of memory for the requested operations.
- Set Memory Use: Amount of run-time memory to use for the requested operations. Specify a
number and the unit of measurement (Megabytes or Gigabytes).
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)