Toad World® Forums

ENABLE QUERY OPTIMIZATION property for MQT

Hi all,

When creating a Materialized Query Table you can specify an option called “ENABLE QUERY OPTIMIZATION” (check the create table command in DB2 LUW 9.7 for instance). I am tryint to find where this property is stored in the catalog but I am not able to get it, I was expecting to find it in SYSCAT.TABLES but it seems it is not there. Can someone help me please ?.

NOTE: there is a similar property for constraints and in that case is is stored in SYSCAT.TABCONST in a column called ENABLEQUERYOPT.

Thanks a lot in advance.

Regards.