Index Manager

 

The Index Manager is a graphical interface to view index definitions, create new indexes and modify or drop existing indexes.

 

Edit Index Definitions and create new Indexes

 

Select a table and start the Index Manager

Use the Database Navigator to select a table. You can only view/modify/create index definitions on a per table basis.

After selecting a table open the Corner Menu in the Content list and select "Index Manager...".

     
 

The list on the left side shows all defined indexes for the selected table. If the list is empty there are no indexes defined for this table.

Display Index Definitions

To display more details on the existing index definitions select the definition from the index list on the left side. The index columns and settings will be shown on the right side.

Create a new Index

Click the + sign on the right side of the indes list to create a new index. A sheet will be displayed. Enter a unique name for your new index and specify the index column and option.

Drop a Index

Select the index in the index list and click the - sign on the right side of the index list to completely remove an index.