Support SQL Performance IDs

This Optional Feature represents one the SQL Performance Monitoring and Diagnostics features provided with this release. These features have been designed specifically for customer-created or custom-invoked SQL, and allow you to view explain plans, track performance history, and get actionable reports for all your saved queries, integration saved queries, and agent actions. These features make it easier to identify and address slow or problematic SQL statements before they impact system performance. This Optional Feature, when enabled, tracks all explicit customer SQL by SQL_ID. The SQL_ID is a unique identifier in the database that allows the application to access explain plans, execution statistics, and other metrics for historical SQL.

See the SQL Performance Monitoring feature for an overview of this SQL Performance feature.

Business Benefit: The SQL performance tools provided in this release allow you to proactively identify and resolve potential SQL performance issues arising from your custom queries, reducing the likelihood of system slowdowns and outages.

You can:

  • Validate custom SQL for syntax and efficiency before deploying it.
  • Easily detect missing conditions in direct SQL updates.
  • Monitor historical execution times and resource usage for your queries.
  • Pinpoint and improve slow ad-hoc queries through diagnostic reporting.

By making it easier to review, optimize, and maintain customer-driven SQL, you can address most issues directly — leading to increased uptime, improved end-user experience, and reduced incident resolution times.

Enabling the use of executed SQL IDs for SQL execution analysis provides access to actual execution statistics for custom SQL, rather than relying solely on estimated explain plans. This leads to more accurate performance diagnostics, faster identification of inefficiencies, and better-informed optimization decisions, helping you maximize database performance and resource utilization.

Steps to Enable and Configure

If you need to change the Opt In state for this feature:

  • Go to the Optional Feature UI - Configuration and Administration > Property Management > Optional Features.

Your user must have the DBA.ADMIN user role to use this functionality.

  • Select the Support SQL Performance IDs feature.
  • Run the Action to Opt Out, assuming there is an issue with the enabled functionality.

Tips And Considerations

Note: Potential Regression - If you Opt In to the Support SQL Performance IDs feature -  internal updates to UPDATE_DATE and UPDATE_USER columns in SAVED_QUERY and AGENT_ACTION_DETAILS tables may affect downstream processes or audits that rely on these fields to reflect only user-driven changes. We recommend that you review any external dependencies.