DBE_SQL_UTIL.create_hint_sql_patch

create_hint_sql_patch is an interface function used to create an SQL patch for optimization and return whether the execution is successful.

Only the initial, sysadmin, opradmin, and monadmin users have the permission to invoke this interface.

Table 1 DBE_SQL_UTIL.create_hint_sql_patch input parameters and return values

Parameter

Type

Description

patch_name

IN name

Specifies the patch name.

unique_sql_id

IN bigint

Queries the global unique ID.

hint_string

IN text

Specifies the hint text.

description

IN text

Specifies the patch description. The default value is null.

enabled

IN bool

Determines whether the patch takes effect. The default value is true.

Feedback
编组 3备份
    openGauss 2024-05-08 00:47:02
    cancel