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 |