[teiid-issues] [JBoss JIRA] Created: (TEIID-900) Refine option no cache behavior

[Steven Hawkins (JIRA)]

Refine option no cache behavior
-------------------------------

                 Key: TEIID-900
                 URL: https://jira.jboss.org/jira/browse/TEIID-900
             Project: Teiid
          Issue Type: Feature Request
          Components: Query Engine
    Affects Versions: 6.0.0
            Reporter: Steven Hawkins
            Assignee: Steven Hawkins
             Fix For: 7.0


Currently specifying option no cache with a particular group name cascades fully through all materialized views.  It would be better if it only applied to a single level.  Simply specifying option no cache without any specific groups would continue to behave the same way as it does currently, which bypasses cache for all materialized views.

The materialized view scripts should be changed to SELECT ... INTO ... FROM x OPTION NOCACHE x so that the loads can take advantage of intermediate materialized view layers.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira