Creating a Database Table Index


The Create Index dialog allows for the creation of new database table indexes within a selected database connection.
  1. Select the menu item Database > Create Index or the Create Index button from the main tool bar
  2. Select the open connection to use for this new table index
  3. Select the database catalog or schema for this new table index
  4. Select the database table where this index is to be applied
  5. Enter a unique index name
  6. Select the type of index to be created from the available options
  7. Select the columns to be index and reorder as required
  8. Verify the generated SQL and make any necessary changes for your database
  9. 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.