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

SQL Anywhere 12.0.1 » SQL Anywhere Server - SQL Usage » Performance improvements, diagnostics, and monitoring » Tips for improving performance » Use materialized views to improve query performance


Materialized views and view matching

The optimizer uses a View Matching algorithm to determine whether materialized views can be used to satisfy a query. The determination involves a query evaluation step, and a materialized view evaluation step.

 Query evaluation step
 Materialized view evaluation step
 See also