Skip to content

Indexes Branch

This branch of the tables list shows all the indexes defined for the table. Each index can have expandable segments. If the table is opened, the appearance of the current index is different from that of the other indexes. If the table is a recnum table, the index RECNUM is present; otherwise, it is not.

Context Menu

The floating menu on Indexes contains the following choices:

Option Action
Resort All Indexes Start a reindex operation for all indexes of the currently pointed and opened table
Find Column by Name Find a column by its name
Find Next Column Find the next occurrence of the column name
Expand Indexes Branch Expand the treeview node
Collapse Indexes Branch Collapse the treeview node
Add Temporary Indexes Add Temporary Indexes for this table
Remove Temporary Indexes Remove Temporary Indexes for this table

The floating menu on each individual index contains the following choices:

Option Action
Rebuild Index Rebuild this index only
Show Index Attributes Open the indexes tab page and move the focus to that page
Find Column by Name Find a column by its name
Find Next Column Find the next occurrence of the column name
Expand Indexes Branch Expand the treeview node
Collapse Indexes Branch Collapse the treeview node

The floating menu on each individual index segment contains the following choice:

Option Action
Sort by Changes the sort order of the datagrid to the main index of this column