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.


0% found this useful

Have a question? Get answers now.

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