Online Documentation for SQL Manager for InterBase/Firebird

Managing indexes


The Indexes tab is provided for managing table indexes. 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, rename, or drop the selected index. Using the menu you can also recompute selected or all indexes, set the index active/inactive, and export the list of the table indexes to any of supported formats.

 

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

 

Table Editor - Managing indexes

 

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

Index Name

On Field(s)

Sorting

Unique

Active

Statistics

Description

 

For details see Indexes.

 

If necessary, you can also use the Index Description area to supply a description for each index.