Creating Relational Indexes

The IBM^® Database Add-Ins for Visual Studio simplify the process of creating IBM database relational indexes. You can use one of the following tools to create a relational index:

The IBM Table Designer, which generates the index as part of a table definition in the Server Explorer.
The DB2^® Create Index Wizard, with which you can generate the index in a database in the Server Explorer or generate an index script in the Solution Explorer.
The Visual Studio Code Editor, with which you can manually insert the SQL statement in the index script file.

With the wizard and the designer, you provide information about the index, specify the columns that you want to define as part of the index, and specify script options for the index.

To create a relational index by using the designer:

Start creating a table or changing a table definition by using the IBM Table Designer.
From the IBM Table Designer menu, select Indexes.
The Indexes view of the IBM Table Designer is displayed.
Add an index and define its properties and columns.
For detailed information about fields in the Indexes view, see Indexes, Designer.
Continue creating the table or changing the table definition.

To create a relational index by using the wizard (from the Server Explorer):

In the Server Explorer, right-click Tables under your data connection, and then select Add Index with Wizard on the shortcut menu.
The DB2 Create Index Wizard opens.
Complete the necessary steps of the wizard.
For detailed information about fields in the wizard, see DB2 Create Index Wizard.
Click Finish.
Based on the options that you select on the Project Selection page in the wizard:
- The script is created and stored in an IBM database project.
- The script is run against the database and the index is created for the table that you specified.

To create a relational index by using the wizard (from the Solution Explorer):

In the Solution Explorer, right-click the Indexes folder under your IBM database project, select Add on the shortcut menu, and then select New Item.
The Add New Item window opens.
In the Categories list, select Indexes.
In the Templates list, select Index Wizard.
In the Name field, type a name for the new index file, and then click Add.
The DB2 Create Index Wizard opens.
Complete the necessary steps of the wizard.
For detailed information about fields in the wizard, see DB2 Create Index Wizard.
Click Finish.
The script file is created and added to your project.

To create a relational index by using the editor:

In the Solution Explorer, right-click the Indexes folder under your IBM database project, select Add on the shortcut menu, and then select New Item.
The Add New Item window opens.
In the Categories list, select Indexes.
In the Templates list, select Index Script.
In the Name field, type a name for the new index file, and then click Add.
A new index file with a basic structure is created and added to your project.
Use the editor to make changes to the index.
To save your changes, select File, and then select Save [file name].

See Also