SQL Reference Guide > SQL Reference Guide > SQL Statements > CREATE TABLE > Smart Minmax
Was this helpful?
Smart Minmax
Smart Minmax is controlled by the DBMS server parameter default_minmax_index in the config.dat file. When an X100 table is created, this parameter determines if a minmax index will be created and the columns that will be used in the minmax index.
The default_minmax_index parameter is applicable to the following tables:
1. A table created without specifying 'with minmax' or 'with nominmax'.
2. A table created using 'with minmax' without specifying the columns. For example: (with minmax=(col1,col3)
The default value for default_minmax_index is AUTO.
Note:  OFF_WITH_AUTO_TUNE is not a valid setting.
auto_tune adds the ability to dynamically add or remove columns from the minmax index after the queries are run.
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