Optimizing schema

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

1. Click Designer Studio > System > Database.
2. Click the Optimize Schema tab.
3. Select the database for which you want to view optimization suggestions.
4. 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.
5. Click Proceed with Changes to apply the selected optimizations.
6. Click Submit.