Q: Can the local index partition and data partition be in the same table space for each partition?
Q:每个分区的本地索引分区和数据分区能否处于同一表空间中?
Q: Why can't I specify a table space for my local index using the CREATE index statement?
Q:为什么我无法利用CREATE index语句为我的本地索引指定表空间?
Since MQTs are local tables that cache the results of a query, the same considerations for creating an index on a local table apply to creating indexes on MQTs.
因为 MQT 是缓存查询结果的本地表,所以在本地表上创建索引的相同步骤也可应用于在 MQT 上创建索引。
应用推荐