Create/Drop Indexes

About Create/Drop Indexes

This option is used to Create or Drop Indexes for System and CES User classes owned by the cisdba schema.

This task explains the procedure to create/drop indexes:

  1. Login as cisdba and run edm.sh from $EDS_HOME/bin directory. For additional information see Using CES Database Manager.

  2. From the EDM main window, select a database for which indexes are to be created or dropped.

  3. Select Tools > Regular Index Management > Create / Drop Indexes option.

    The Create/Drop Indexes window appears
    .


     
    Name Description

    Index Name

    The name of the index.

    Column Name

    The column that is indexed.

    Column Sequence

    Indicates the column order within an index.

    Sorting Order

    The order in which the index data is sorted. This can be ascending or descending.

    Unique Rule

    Indicates if the index is unique.

Select the index to be created or dropped as follows:

  • You can create/drop an index based on the Class Label or the Class DB Name. Depending on your selection, the list of Class names (labels) or the Class DB Names are displayed. You can also enter a Class Label or a Class DB Name in the Search field and retrieve indexes for that class.

  • Select one from the list and click Get Indexes to see a list of existing indexes for the selected class.

Based on your selection, the existing indexes for the System Classes or the User Classes are displayed on the window. You can perform these tasks:

  •  Create an index for a selected class, click Create. The index creation window appears. Enter the Index Name and select the columns from the list and click OK to create the index. While creating the index, you can mark it as Unique, if required. After creating the index, it is added to the existing list of indexes.

  • Drop index for a selected class, select the index(es) and click Drop. A message indicating that the index will be dropped appears. Click OK to drop the index.