Sets the value of the CURRENT MAINTAINED TABLE TYPES FOR
OPTIMIZATION special register.
- db2cli.ini keyword syntax:
- CurrentMaintainedTableTypesForOpt = ALL | FEDERATED_TOOL | NONE |
SYSTEM | USER | <list>
- Default setting:
- System-maintained refresh-deferred materialized query tables are
considered in the optimization of a query.
- Usage notes:
-
This keyword defines the default value for the CURRENT
MAINTAINED TABLE TYPES FOR OPTIMIZATION special register. The value
of the special register affects the types of tables which are considered
in the optimization of a query. Refer to the SET CURRENT MAINTAINED
TABLE TYPES FOR OPTIMIZATION SQL statement for details on the supported
settings of ALL, FEDERATED_TOOL, NONE, SYSTEM, or USER. The <
list>
option represents a combination of the supported settings, however,
ALL and NONE cannot be specified with any other value, and the same
value cannot be specified more than once. Separate each value in
the list with a comma, for example:
CurrentMaintainedTableTypesForOpt = SYSTEM,USER
DB2 Version 9.7 for Linux, UNIX, and Windows