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

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

rakeshsagar Mar 22, 2013 12:12 PM

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.

1. Re: Materialized View Using TTL Snapshot Refresh VS a view with cache hint

rareddy Mar 22, 2013 12:23 PM (in response to rakeshsagar)

Rakesh,

One is materialized view, the cached results used across system with all the sessions with any query that are based on that view.

When you place it on view, it is simply a "resultset" caching, depending upon the scope of the query it may be available to that particular session or other sessions, but the the system will serve these results only in the case the submitted user query matches exactly to the one it created cached results with.

Ramesh..
Actions
2. Re: Materialized View Using TTL Snapshot Refresh VS a view with cache hint

rakeshsagar Mar 25, 2013 1:32 AM (in response to rareddy)

Thanks Ramesh.
Actions