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
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1