DB2 10.5 for Linux, UNIX, and Windows
DB2 10.5 for Linux, UNIX, and Windows
The CURRENT MAINTAINED TABLE TYPES FOR OPTIMIZATION special register specifies a VARCHAR(254) value that identifies the types of tables that can be considered when optimizing the processing of dynamic SQL queries. Materialized query tables are never considered by static embedded SQL queries.
The initial value of CURRENT MAINTAINED TABLE TYPES FOR OPTIMIZATION is set to the value of the dft_mttb_types database configuration parameter. The default value of dft_mttb_types parameter is SYSTEM.