Skip to main content

Table of Contents

Removing the optimized status from a property


Only available versions of this content are shown in the dropdown

Deoptimize a property that you previously optimized to completely clear the optimized property from a database schema. A deleted optimized property falsely retains its optimized status through its property-optimization log associations upon its recreation, and Pega Platform cannot optimize the property again. Deoptimize the property to completely clear its status from the schema and table in order to optimize the property again.

Complete the following actions before deoptimizing a property:
  • Note the name and class of the property that you want to deoptimize. You need the name of the property and its class to locate its unused column and property optimization log association.
  • Delete the property that you want to remove from your database schema. For more information, see Deleting a data object.

    To view schema suggestions and apply changes to a schema, your access group must have the ViewAndOptimizeSchema privilege and set the dynamic system setting database/AutoDBSchemaChangesmust to true.

  1. Drop the column containing the deleted property using the Optimize Schema wizard:

    1. In the header of Dev Studio, click Configure System Database Optimize Schema .

    2. In the Select Database list, select the database schema that contains the table and column of the property that you deleted.

    3. Select View the unused columns.

    4. Select the column associated with the property that you deleted.

    5. Click Proceed with Changes to apply the selected optimizations.

    6. Click Submit.

  2. Remove the property optimization log association from the deleted property:

    1. In the navigation pane of Dev Studio, click App Classes , and enter Log-System-PropertyOptimization in the Search field.

    2. In the Criteria section, in the Key Contains field, enter the property name and its class name in the following format: <propertyName>!<className>.

    3. Select the resulting property.

    4. In the Edit Log-System-PropertyOptimization window, select Delete.

    You removed the optimization from the property. If you need to, you can now recreate the property without its optimized status.

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