Example: Creating an Index

When you create an index, you specify one or more table columns to be indexed and the type of index to create.

In this example, you create a standard B-tree index on the SUPPLIER_ID column in the SH.PRODUCTS table. (The SH schema is part of the sample schemas.)

To create a supplier index on the SH.PRODUCTS table:

1. View the tables in the SH schema, by following the instructions in the section "Viewing Tables".

2. Select the PRODUCTS table.

3. In the Actions list, select Create Index, and then click Go.

   The Create Index page appears.

4. Enter the following information:

   • In the Name field, enter PRODUCTS_SUPPLIER_IDX.

   • For the Tablespace field, accept the default value.

   • For Index Type, select Standard - B-tree.

   • In the Table Columns list, select the SUPPLIER_ID column by entering 1 in the Order column.

     If your index were to consist of multiple columns (a concatenated index), then you would enter 2 in the next column to include, and so on. These numbers indicate the order in which the columns are to be concatenated, from left to right, or from most significant in the sort order to least significant.

   • For Sorting Order, accept the default selection of ASC (ascending).

5. Click OK to create the index.

   The Indexes page returns and displays a confirmation message. The new index is listed in the table of indexes.