All Products
Search

This Product

    :Execute an SQL statement in DMS and the system prompts "The current SQL does not meet the performance security requirements of the database"

    Document Center

    :Execute an SQL statement in DMS and the system prompts "The current SQL does not meet the performance security requirements of the database"

    Last Updated:Feb 27, 2023

    Issue description

    The current SQL statement does not meet the performance security requirements of the database. Optimize the SQL statement, check the execution plan to reduce the performance overhead, and then try again.

    Cause

    When you manage data by using Data Management (DMS), DMS limits the amount of data that you can query and the number of times that you can access the database on the current day. If the amount of data that you query or the number of times that you access the database exceeds the limit, DMS blocks access to the database to prevent data leaks.

    Solution

    You can use one of the following methods to resolve this issue:

    • Modify the security rules and specify a greater value for the Limit the maximum allowed SQL full table scan (MB) parameter. For more information, see SQL Console for relational databases.

    • Modify the execution plan.

      • Modify the SQL statement: Add more filter conditions to the WHERE clause to prevent invalid data from being scanned.

      • Add indexes: Add indexes to one or more columns specified in the WHERE clause to optimize the execution plan so that not all data in the table is scanned.