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 pre-computing expensive operations in the form of a view that is stored on disk.
To create a materialized view owned by you, you must have the CREATE MATERIALIZED VIEW system privilege along with SELECT privilege on all underlying tables.
To create materialized views owned by others, you must have the CREATE ANY MATERIALIZED VIEW or CREATE ANY OBJECT system privileges along with SELECT privilege on all underlying tables.
In Sybase Central, use the SQL Anywhere 16 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.
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|