Create a materialized view to store data from queries that are frequently executed and that result in repetitive aggregation and join operations on large amounts of data. Materialized views can improve performance by precomputing expensive operations in the form of a view that is stored on disk.
Prerequisites
You must have DBA or RESOURCE authority.
Context and remarks
Many.
Create a materialized view using Sybase CentralUse the SQL Anywhere 12 plug-in to connect to the database.
In the left pane, right-click Views and click New » Materialized View.
Follow the instructions in the Create Materialized View Wizard.
Results
A non-initialized materialized view is created in the database. It does not have any data in it yet.
Next
You must initialize the materialized view to populate it with data before you can use it.
See also |
Discuss this page in DocCommentXchange.
|
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1 |