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