This content has been marked as final.
Show 2 replies
-
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..
-
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.