SET QUERY_GOVERNOR_COST_LIMIT#

Overrides the currently configured query governor cost limit value for the current connection.

Syntax#

SET QUERY_GOVERNOR_COST_LIMIT value  [;]

Arguments#

value

Is a numeric or integer value specifying the longest time in which a query can run. Values are rounded down to the nearest integer. Negative values are rounded up to 0.

Remarks#

Argument values are ignored and do not change the default behavior.

Permissions#

Requires membership in the public role.

See Also#