To create an index:

  1. Click the Indexes object in the tree. The indexes in the database are listed.

  2. Click the Create button. The Create IndexWizard is displayed.

  3. Click the Next button. The Name the Index window is displayed.

  4. From the Table Name menu, select the table name that the index will refer to.

  5. Select a tablespace to build the index in. Building an index on a different tablespace may result in better disk I/O, especially if the tablespaces reside on separate disks.

  6. Enter a name for the Index in the Index Name field.

  7. Click the Next button. This will open the Select the column(s) to be indexed window.

  8. A list of available columns on the selected table appears on the left hand list box. Select the columns that you want to use in the index by double clicking on the column name or selecting the column and clicking the Add button. The Add all button can be used to add all columns to the index. All the columns selected for the creation of the index will be displayed in the list box to the right. Columns in the index can be, likewise removed by double clicking on the column name or selecting the column and clicking the Remove button.

  9. To change the sorting order to descending for a column:

    1. Select a column from the list box to the right.

    2. Click the cell in the Desc column for the selected column in the list box to the right. A check mark in the box indicates that the order for that column's index is descending

      Note: By default, the sort order is ascending.

  10. Click the Next button. The Advanced Information window appears.

  11. If you want the index to be unique, select the Unique option button.

  12. To change the default fill factor, enter a percentage in the Fill Factor field.

  13. Click the Next button. The Final review dialog box is displayed.

  14. Click the Finish button after checking that the SQL script is correct. The Information dialog box appears.

  15. Click OK.


Related topic:

Creating an Index