Online Documentation for SQL Manager for Oracle

Creating/editing index type


Use the Index type tab of Index Type Editor to create/edit an index type and specify its properties.

 

Name

Specify the name of the index type to be created, or view the name of the index type being edited. Note that the index type name must be unique within its schema.

 

Schema

Use the drop-down list to specify the schema in which the index type will be created.

 

Index Type Editor - Editing Index Type definition

 

For operators

This group allows you to specify the list of operators supported by the index type.

 

Operator schema

Use the drop-down list to select the schema containing operator(s) for the index type.

 

To select an operator, you need to move it from the Available list to the Selected list. Use the Move all to Selected Move to Selected Move to Available Move all to Available buttons or drag-and-drop operations to move the operators from one list to another.

 

Implementation schema

Displays the schema containing the implementation type (must reside in the same schema as the index type).

 

Implementation object

Type in the name of the type that provides the implementation for the new index type.

 

To compile the object, use the corresponding iconCompile Compile item of the Navigation bar or toolbar.