Optimizing a schema

You can view possible database optimizations that could improve the system performance, database size or other resource use.

Before you begin: To view schema suggestions and apply changes, your access group must have the ViewAndOptimizeSchema privilege and the dynamic system setting database/AutoDBSchemaChanges must be true.
  1. In the header of Dev Studio, click Configure > System > Database > Optimize Schema.
  2. Select the database for which you want to view optimization suggestions.
  3. Select the type of suggestions you want to view.
    • Index suggestions – To view an application other than the current application, select it from the Filter by Application list. Click Create to create an index for a column.
    • Unused tables – Click Instance Count to view the classes that were mapped to the associated table and their individual instance counts.
    • Unused columns – Select whether to drop these columns from the table.
    • Invalid class mappings – To view an application other than the current application, select it from the Filter by Application list.
  4. Click Proceed with Changes to apply the selected optimizations.
  5. Click Submit.