Online Documentation for SQL Manager for DB2

Managing indices


The indices tab is provided for managing table indices. Double-click an index to open Index Editor for editing the index.

 

Right-click an index to display the context menu allowing you to create new, edit, or drop the selected index. Using the menu you can also export the list of the table indexes to any of supported formats.

 

Indices management tools are also available through the Navigation bar of Table Editor.

 

Table Editor - Managing indexes

 

 

The Indices list provides the following attributes of each index of the table:

Index name

On fields

Unique

Collation

Comment

 

For details see Indices.