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

User Interface - Navigation tree - Indexes 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

Data warehouse > Indexes context menu
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

Data warehouse > Indexes > DWH.DIM_Invoices_T.Ix_Order context menu
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.