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.
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:
Discuss this page in DocCommentXchange.
|Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1|