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.

Open topic with navigation