This content has been marked as final.
Show 3 replies
-
1. Re: Delay loading of Materialized Views
rareddy Jan 23, 2013 10:38 AM (in response to rakeshsagar)Rakesh,
Are those internal materialized tables? Materialization only runs when the first time you access that view. If you do not want to load the materialized the very first time, then issue command with "NO CACHE" option.
Ramesh..
-
2. Re: Delay loading of Materialized Views
rakeshsagar Jan 23, 2013 11:09 AM (in response to rareddy)Yes, we are using the internal materialized tables. Should we include the NO CACHE in the materialized view definition?
-
3. Re: Delay loading of Materialized Views
rareddy Jan 23, 2013 11:38 AM (in response to rakeshsagar)No, on your user query, which is triggering the materialization load.