Indexes
Overview
The Indexes navigation tree branch opens table index definitions.
Function
Use the branch or DWH toolbar command to open the index list.
The list shows schema, table, index name, clustered, unique, and primary-key settings with new and delete actions.
Access
Open the Indexes branch from the navigation tree or use the DWH toolbar tab.
How to access
Navigation tree
Indexes -> List indexes.
Toolbar
DWH -> Indexes.
Diagram
Not opened directly from the diagram.
Visual element
Indexes navigation branch and list
Screen overview
Context menus access - Indexes - Where I can find it
The context menu examples below use the captured Data warehouse > Indexes navigation tree branch and show the index branch, an index node, and an index-column node.
A.1) Indexes
| ID | Command | Description |
|---|---|---|
| 1 | Refresh | Reloads the Indexes branch. |
| 2 | List indexes | Opens the indexes list. |
| 3 | Add index | Creates an index from the selected context. |
| 4 | List scripts | Lists scripts available for the selected context. |
| 5 | Add script | Adds a script to the selected context. |
| 6 | Run script | Runs a script for the selected context. |
A.2) Indexes > DWH.DIM_Invoices_T.Ix_Order
| ID | Command | Description |
|---|---|---|
| 1 | Refresh | Reloads the selected index node. |
| 2 | Edit index | Opens the selected index for editing. |
| 3 | Delete index | Deletes the selected index. |
