Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.1 » SQL Anywhere Server - SQL Usage » Tables, views, and indexes » Materialized views


Enabling or disabling a materialized view

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


 Enable or disable a materialized view using Sybase Central
  1. Use the SQL Anywhere 12 plug-in to connect to the database.

  2. In the left pane, double-click Views.

  3. To enable a materialized view:

    1. Right-click the view and click Recompile And Enable.

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

  4. To disable a materialized view, right-click the view and click Disable.


When you enable a materialized view, it becomes available for use by the database server and you can query it.

When you disable a materialized view, the data and indexes are dropped. If the view was an immediate view, it is changed to a manual view.

Querying a disabled materialized view fails and returns and error.


After you re-enable a view, you must rebuild any indexes for it, and change it back to an immediate view if it was an immediate view when it was disabled.

 See also