You can control whether a materialized view is available for querying by enabling and disabling it.
You must have DBA authority or be the owner of the materialized view.
Context and remarks
Use the SQL Anywhere 12 plug-in to connect to the database.
In the left pane, double-click Views.
To enable a materialized view:
Right-click the view and click Recompile And Enable.
(optional) Right-click the view and click Refresh Data to populate the view with data. This step is optional because the first query after enabling would also cause the view to be populated with data.
To disable a materialized view, right-click the view and click Disable.
Discuss this page in DocCommentXchange.
|Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1|