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

SQL Anywhere 12.0.0 (Français) » SQL Anywhere Server - SQL Usage » Query optimization and execution » Improving performance with materialized views » Materialized views and the View Matching algorithm

 

View Matching algorithm examples

 Example 1: Matching select-project-join views
 Example 2: Matching grouped-select-project-join views
 Example 3: Matching complex queries
 Example 4: Matching materialized views with OUTER JOINs