Skip to main content
LinkedIn
Copied!

Table of Contents

Optimizing a schema

Version:

Only available versions of this content are shown in the dropdown

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

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.

Related Content

Did you find this content helpful?

Have a question? Get answers now.

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

Ready to crush complexity?

Experience the benefits of Pega Community when you log in.

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

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us