2 Replies Latest reply on Mar 25, 2013 1:32 AM by Rakesh Balguri

    Materialized View Using TTL Snapshot Refresh VS a view with cache hint

    Rakesh Balguri Expert

      Hi,

       

      I was thinking about the difference between the Materialized View Using TTL Snapshot Refresh and a view with cache hint.

       

      For example:

       

      Materialized View:

       

      CREATE VIEW test_materialized_view (

                col1integer,

          col2 varchar,

          ) OPTIONS (MATERIALIZED 'true')

          AS /* cache(ttl:30000) */ SELECT  col1, col2 from test_table

       

       

      View with cache hint:


      /* cache(ttl:30000) */ SELECT  col1, col2 from test_table

       

      Can anyone please let us know the difference between these both.

       

       

      Thanks

      Rakesh.