TimesTen支持缓存视图吗

来源:互联网 发布:印度人在中国 知乎 编辑:程序博客网 时间:2024/05/17 09:32

问这个问题的初衷是希望能够在Oracle中通过视图关联多张表,然后将结果集缓存到TimesTen.

不过答案是不支持,在Cache User Guide第245页,明确指出:

TimesTen supports views and materialized views, but it cannot cache an Oracle Database view. TimesTen can cache an Oracle Database materialized view in a user managed cache group without the AUTOREFRESH cache group attribute and PROPAGATE cache table attribute. The cache group must be manually loaded and flushed.

视图是不支持的,物化视图支持,但有太多限制条件。所以视图之类的就别考虑的,原因应该是视图不能保证主键或唯一索引

0 0