All Products
Search

This Product

    Database Autonomy Service:UpdateAutoSqlOptimizeStatus

    Document Center

    Database Autonomy Service:UpdateAutoSqlOptimizeStatus

    Last Updated:Mar 13, 2026

    Enables, modifies, or disables the automatic SQL optimization feature for multiple database instances at a time.

    Operation description

    Before you call this operation, take note of the following items:

    • If you use an SDK to call API operations of Database Autonomy Service (DAS), you must set the region ID to cn-shanghai.

    • DAS Enterprise Edition must be enabled for the database instance that you want to manage. To enable DAS Enterprise Edition for a database instance, you can call the EnableDasPro operation.

    • The autonomy service must be enabled for the database instance. For more information, see Autonomy center.

    • This operation supports the following database engines:

      • ApsaraDB RDS for MySQL High-availability Edition or Enterprise Edition

      • PolarDB for MySQL Cluster Edition

    Try it now

    Try this API in OpenAPI Explorer, no manual signing needed. Successful calls auto-generate SDK code matching your parameters. Download it with built-in credential security for local usage.

    Test

    RAM authorization

    The table below describes the authorization required to call this API. You can define it in a Resource Access Management (RAM) policy. The table's columns are detailed below:

    • Action: The actions can be used in the Action element of RAM permission policy statements to grant permissions to perform the operation.

    • API: The API that you can call to perform the action.

    • Access level: The predefined level of access granted for each API. Valid values: create, list, get, update, and delete.

    • Resource type: The type of the resource that supports authorization to perform the action. It indicates if the action supports resource-level permission. The specified resource must be compatible with the action. Otherwise, the policy will be ineffective.

      • For APIs with resource-level permissions, required resource types are marked with an asterisk (*). Specify the corresponding Alibaba Cloud Resource Name (ARN) in the Resource element of the policy.

      • For APIs without resource-level permissions, it is shown as All Resources. Use an asterisk (*) in the Resource element of the policy.

    • Condition key: The condition keys defined by the service. The key allows for granular control, applying to either actions alone or actions associated with specific resources. In addition to service-specific condition keys, Alibaba Cloud provides a set of common condition keys applicable across all RAM-supported services.

    • Dependent action: The dependent actions required to run the action. To complete the action, the RAM user or the RAM role must have the permissions to perform all dependent actions.

    Action

    Access level

    Resource type

    Condition key

    Dependent action

    hdm:UpdateAutoSqlOptimizeStatus

    update

    *All Resource

    *

    		 None None

    Request parameters

    Parameter

    Type

    Required

    Description

    Example
    Instances

    string

    Yes

    The database instance IDs. Separate multiple IDs with commas (,).

    Note

    You can specify up to 50 instance IDs.

    rm-bp10usoc1erj7****,rm-bp10usoc1erj7****
    Status

    integer

    Yes

    The status of the automatic SQL optimization feature. Valid values:

    • 0: The automatic SQL optimization feature is disabled.

    • 1: SQL diagnosis and automatic index creation is specified.

    • 3: SQL diagnosis only is specified.

    1

    Response elements

    Element

    Type

    Description

    Example

    object

    Code

    string

    The HTTP status code returned.

    200
    Message

    string

    The returned message.

    Note

    If the request was successful, Successful is returned. If the request failed, an error message such as an error code is returned.

    Successful
    Data

    object

    The returned data.

    Success

    string

    Indicates whether the request initiated to configure the automatic SQL optimization feature was successful. Valid values:

    • true

    • false

    false
    ErrorCode

    string

    The error code. Valid values:

    • -1001: indicates that the specified parameter is invalid.

    • -91029: indicates that a system error occurred.

    -1001
    ErrorMsg

    string

    The error message.

    invalid param
    RequestId

    string

    The request ID.

    A52AD37C-35ED-581A-AC23-2232BE54****
    Success

    string

    Indicates whether the request was successful. Valid values:

    • true

    • false

    true

    Examples

    Success response

    JSON format

    {
  "Code": "200",
  "Message": "Successful",
  "Data": {
    "Success": "false",
    "ErrorCode": "-1001",
    "ErrorMsg": "invalid param"
  },
  "RequestId": "A52AD37C-35ED-581A-AC23-2232BE54****",
  "Success": "true"
}

    Error codes

    HTTP status code

    Error code

    Error message

    Description
    400 InvalidParams The request parameters are invalid.
    403 NoPermission You are not authorized to do this action.

    See Error Codes for a complete list.

    Release notes

    See Release Notes for a complete list.