How to create indexes on MQT(materialized query table) in Db2?
How to create indexes on MQT(materialized query table) in Db2? I haven't found this information in documentation? Is 开发者_运维知识库index creation syntax the same as for common tables?
After you create your MQT you have to refresh the table before you can create indexes. However, at this point it's exactly the same as creating indexes on a normal table.
There are some limitations on what type of indexes you can create on an MQT. For example, it cannot be a unique index.
精彩评论