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.