Enabling or disabling a materialized view

You can control whether a materialized view is available for querying by enabling and disabling it.

Prerequisites

You must be the owner of the materialized view or have one of the following system privileges:

ALTER ANY MATERIALIZED VIEW
ALTER ANY OBJECT

To enable a materialized view, you must also have the SELECT privilege on the underlying table(s) or the SELECT ANY TABLE system privilege.

Task

In Sybase Central, use the SQL Anywhere 16 plug-in to connect to the database.

In the left pane, double-click Views.

Option	Action
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 that is run against the views after enabling it would also cause the view to be populated with data.
Disable a materialized view	Right-click the view and click Disable.

Results

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.

Next

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.

Enabling or disabling a materialized view

Task

See also