Index: General

Name: Name of the index.

Schema: Schema that owns the index.

Index On:

The following items are displayed if you are editing an existing index.

Add Stop Words: Lets you add one or more stop words to the index. To add a stop word, click <NEW STOPWORD> at the end of the list, type the stop word, and press Enter. To delete a stop word from the list, either select it and press Delete or right-click the gray button to the left of the name and select Remove.

Add Stop Sections: Lets you add one or more stop sections to the index. (Not available if you are connected to a pre-release 8.1.6 database or if the index does not have an AUTO_SECTION_GROUP section group.) To add a stop section, click <NEW STOP SECTION> at the end of the list, type the stop section, and press Enter. To delete a stop section from the list, either select it and press Delete or right-click the gray button to the left of the name and select Remove.

Note: Any stop words or stop sections that you add are not added to the stoplist specified on the Preferences tab. If you later specify another stoplist using the Preferences tab, any stop words or stop sections that you specified on this General tab are removed, and the index contains only the stop words and stop sections in the newly specified stoplist. You cannot delete stop words from an index; as a workaround, you can create a new stoplist containing only the desired entries, and then specify that stoplist using the Preferences tab.

The following items are displayed if you are creating an index.

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.

Online: Allows the index to be online (that is, allows the index to be queried) during operations that alter the index (such as a rebuild or optimization).

Populate: Populates an empty index by updates or inserts to the base table. If you do not select Populate, the index is created empty. You might create an empty index when you require only theme and Gist output from a document set. In addition, you might create an empty index to subsequently index only a subset of documents in the base table.

Note: If you encounter any error or warning messages, you can view the details by starting SQL*Plus Worksheet and entering the following statement: select * from dr$index_error;

Note: To perform any of the following operations on an index, you must use the Object menu or the right-mouse menu:

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

See also: Main topics (outline)