开发者

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.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜