3 Replies Latest reply on Jan 23, 2013 11:38 AM by Ramesh Reddy

    Delay loading of Materialized Views

    Rakesh Balguri Expert

      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