 |
Creating a Database Table Index
|
 |
The Create Index dialog allows for the creation of new database table
indexes within a selected database connection.
|
 |
- Select the menu item Database > Create Index or the Create
Index button from the main tool bar
- Select the open connection to use for this new table index
- Select the database catalog or schema for this new table
index
- Select the database table where this index is to be applied
- Enter a unique index name
- Select the type of index to be created from the available
options
- Select the columns to be index and reorder as required
- Verify the generated SQL and make any necessary changes for your
database
- Select the Create button
|
The index is generated using the generated SQL text following relevant
entries within the fields provided. Changes made to the SQL text are NOT
reflected within the field display values. |