Delay loading of Materialized Views

[rakeshsagar]

Hi all,

The materialized views are loaded after the VDB is active.

My use case is that, we run "Alter" command on all the views after the VDB is active and after the "Alter" is completed we are invalidating all the materialized views.

This works fine but some of our views have huge amount of data and we end up loading the materialized views twice.

Is there any way by which we can tell teiid not to load the materialized views after the VDB is active?

Any help would be appreciated.

Thanks

Rakesh

[rareddy]

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..

[rakeshsagar]

Yes, we are using the internal materialized tables. Should we include the NO CACHE in the materialized view definition?

[rareddy]

No, on your user query,  which is triggering the materialization load.