1 Reply Latest reply on Jul 30, 2013 8:51 AM by Ramesh Reddy

    Is this the right way to test Result set Cache?

    Vivedha Elango Newbie

      Hi

      I am Using Teiid 7.7.5 + Teiid Designer 7.8 + Eclipse Indigo , I tried creating a VDB with a Result set Cache

      1. I changed the transformation in the view

      /*+ cache(ttl:300000) */SELECT * FROM SourceSample.Air_travel

      2. Then I executed the VDB and tested the cache.

      But the data is not cached.

       

      Is this the right way to test Result set Cache?

      Is there any articles to work on Cache without materialized views?