TimesTen支持缓存视图吗

3/7/2017来源:SQL技巧人气:1907

问这个问题的初衷是希望能够在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.

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