Even if a query doesn't reference a materialized view, the optimizer can decide to use the view to satisfy a query if doing so improves performance. You can enable or disable the optimizer's use of a materialized view for satisfying queries.
You must have DBA authority or be the owner of the materialized view.
Context and remarks
Use the SQL Anywhere 12 plug-in to connect to the database.
In the left pane, double-click Views.
Right-click the materialized view and click Properties.
Click the General tab and select or clear Used In Optimization, as appropriate.
Discuss this page in DocCommentXchange.
|Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1|