4 Replies Latest reply on Feb 1, 2016 8:20 AM by Steven Hawkins

    how do materialized views work

    Prashanthi Kairuppala Novice

      Hi,

       

      We are trying materialized views. We enable 'Materialized=true' in table properties and added ttl cache in select query.

      When we try the odata URL like /odata/table('Data1')?$format=json, it is not fetching the data if their is any duplicate entry for the column which is the primary key, even though 'Data1' is unique row.

       

      i would like to know if the url i fired is doing a full table scan and storing the complete result in cache and then getting data, from cache? If so we would not try the cache option on our view tables. Please help.

       

      Thanks in advance,

      Prashanthi.