Optimizing schema

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

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.