Product Documentation

Appearance

All platforms

SETTING Clause ​

As a way to influence planner optimization and query execution, you can specify a SETTING clause at the beginning of the following SQL commands:

  • SELECT
  • INSERT INTO SELECT
  • UPDATE
  • DELETE
  • CREATE TABLE AS (CTAS)
  • EXPLAIN (with the commands in this list)

Note: The values you specify in the SETTING clause remain in effect for the duration of a single SQL statement. Values do not persist for the life of the session or transaction.

The SETTING clause syntax is as follows:

SETTING ( hint [ ; hint ... ] )

where hint must be one of the available hints :

If a SELECT statement contains a WITH clause (common table expression) and a SETTING clause, the SETTING clause must precede the WITH clause.

Note When using SETTING to inject multiple hints, they must be separated by a semicolon

See Plan Hinting for all details on available hints and how to use them.