Adding and deleting database indexes

You can add and delete indexes on the Schema Tools landing page. These operations can take some time to complete. After initiating an operation, you can view progress and verify completion by refreshing the landing page and clicking the History tab for the table containing the index.

  1. In the header of Dev Studio, click Configure > System > Database > Schema Tools.
  2. Select the table for the index to view the list of existing indexes.
    • To add an index:
      1. Click Add index.
      2. Enter a name for the index.
      3. Enter a list of one or more columns or functions, in order, for the index.
      4. Click Create index.
    • To delete an index:
      1. Select the index that you want to delete.
      2. Click Delete.