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

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - SQL Usage » Tables, views, and indexes » Materialized views » Advanced: Status and properties for materialized views


Status and property changes when altering, refreshing, and truncating a materialized view

Operations you perform on a materialized view, such as altering, refreshing, and truncating, impact the view's status and properties. The following diagram shows how these tasks impact the status and some of the properties of a materialized view.

In the diagram, each gray square is a materialized view; immediate views are identified by the term IMMEDIATE, and manual views by the term MANUAL. The term ALTER in the connectors between grey boxes is short for ALTER MATERIALIZED VIEW. Although SQL statements are shown for changing the materialized view status, you can also use Sybase Central to perform these operations.

Diagram showing the various states for materialized views
  • When you create a materialized view, it is an enabled manual view and it is uninitialized (contains no data).

  • When you refresh an uninitialized view, it becomes initialized (populated with data).

  • Changing from a manual view to an immediate view requires several steps, and there are additional restrictions for immediate views.

  • When you disable a materialized view:

    • the data is dropped
    • the view reverts to uninitialized
    • the indexes are dropped
    • an immediate view reverts to manual
 See also