Name: Name of the index.
Schema: Schema that owns the index.
Index On:
Full & Maximum Time: Specifies a full optimization that can take up to the Maximum Time number of minutes. This method compacts rows and removes old data (garbage collection). The default for Maximum Time is unlimited, in which case the entire index is optimized. If you specify a value for Maximum Time, Oracle interMedia Text starts the optimization where it left off and optimizes until complete or until the time limit has been reached, whichever comes first. Specifying a time limit is useful for automating index optimization, where you set Oracle interMedia Text to optimize the index for a specified time on a regular basis. If you specify 0 for Maximum Time, minimal optimization is performed.
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:
See also: Main topics (outline)