Index: General (for Synchronize Operations)

Name: Name of the index.

Schema: Schema that owns the index.

Index On:

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).

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)