MAKE_INDEX

The MAKE_INDEX administration method creates an index for any persistent object type. You can specify one or more properties on which to build the index. If you specify multiple properties, you must specify all single-valued properties or all repeating properties. Also, if you specify multiple properties, the sort order within the index corresponds to the order in which the properties are specified in the statement. You can also set an option to create a global index.

If the MAKE_INDEX method succeeds, it returns the object ID of the dmi_index object for the new index. If the method fails, MAKE_INDEX returns F. If the specified index already exists, the method returns 0000000000000000.

You must have superuser privileges to run the MAKE_INDEX administration method. To run an index space query, you must have sufficient privileges in the database.

To run the MAKE_INDEX administration method:

Navigate to Administration > Job Management > Administration Methods.
The system displays the Administration Methods list page.
Click MAKE_INDEX.
The system displays the Parameters page.
Enter information on the Parameters page:
1. Type Name: Select a name type from the drop-down list box.
2. Attribute Name: Select a property name from the drop-down list box.
3. Unique: Select if the values in the index must be unique.
4. Index Space: Select a specific tablespace or segment in which to place the new index.
5. Global Index: Select to create a global index.
  The Global Index option:
  - Is available only on version 6.5 repositories.
  - Is available only for partitioned types.
  If selected, the global index is applied to all partitions.
To identify a specific tablespace or segment in which to place the new index, select the tablespace or segment from the Index Space drop-down list.
You must have sufficient privileges in the database to do this.
Global Index:
Click Run.
The method runs and the results are displayed.
Click Close.
The system displays the Administration Methods list page.