Online Documentation for SQL Manager for DB2

Indices


Table indices are managed within the Indices tab of Table Editor.

 

 

Creating Indices

 

To create a new table index:

  • open the table in Table Editor;
  • proceed to the Indexes tab there;
  • right-click the tab area and select the New Index context menu item;
  • define the index properties using the Index Editor dialog.

 

Editing Indices

 

To edit an existing table index:

  • open the table in Table Editor;
  • proceed to the Indices tab there;
  • right-click the index and select the Edit Index context menu item, or simply double-click the index;
  • edit the index properties using the Index Editor dialog.

 

Dropping Indices

 

To drop a table index:

  • open the table in Table Editor;
  • proceed to the Indices tab there;
  • right-click the index and select the Drop Index context menu item;
  • confirm dropping in the dialog window.