SQL Reference Guide > SQL Reference Guide > SQL Statements > SET > DEFAULT_MINMAX_INDEX
Was this helpful?
DEFAULT_MINMAX_INDEX
Overwrites the default_minmax_index for the current session. This option can be set in the config.dat file (DBMS Server Parameters) and in session.
Note:  Setting default_minmax_index to OFF WITH AUTO_TUNE is not permitted.
The default is AUTO.
The following table lists the valid values for default_minmax_index:
Valid Values
Description
OFF
No minmax index will be created, even if the create table statement specifies 'WITH MINMAX' with no columns.
ALL
All columns are used in the minmax index.
AUTO
An internal heuristic decides the columns to be used in the minmax index.
NONE
No columns are used in the minmax index, but the minmax index is created.
KEYS
Columns with unique or primary or referential constraints specified during the create table statement are used.
An internal heuristic decides which columns with unique constraints are used.
ALL WITH AUTO_TUNE
Same as ALL, but also enable auto_tune heuristics.
AUTO WITH AUTO_TUNE
Same as AUTO, but also enable auto_tune heuristics.
NONE WITH AUTO_TUNE
Same as NONE, but also enable auto_tune heuristics.
KEYS WITH AUTO_TUNE
Same as KEYS, but also enable auto_tune heuristics.
Last modified date: 08/14/2024