Skip to main content

Optimizing a schema

Suggest edit Updated on May 11, 2022

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 ConfigureSystemDatabaseOptimize 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.
Did you find this content helpful? YesNo

Have a question? Get answers now.

Visit the Support Center to ask questions, engage in discussions, share ideas, and help others.

We'd prefer it if you saw us at our best.

Pega.com is not optimized for Internet Explorer. For the optimal experience, please use:

Close Deprecation Notice
Contact us