 |
-
Login as cisdba and run edm.sh from $EDS_HOME/bin
directory. For additional information see
Using CES Database Manager.
-
From the EDM main window, select a database for which
indexes are to be created or dropped.
-
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.
|