A materialized view uses pre-computation to accelerate queries. It stores the results of time-consuming operations, such as JOINs and aggregations, so the results can be directly reused at query time, which avoids repeating these expensive operations. This topic describes how to view and manage materialized views in HoloWeb.
Prerequisites
-
You are logged in to an instance. For more information, see log on to an instance.
-
The Hologres instance must be V1.3 or later. If the instance is an earlier version, upgrade it. For more information, see upgrade an instance.
Manage materialized views
Log on to the Hologres management console.
In the top navigation bar, select a region.
Click Go to HoloWeb to open the HoloWeb developer page.
-
On the Metadata Management page, locate the materialized view in the navigation pane on the left by using the search box or browsing the Instances Connected list.
You can perform the following operations:
-
Refresh
After you create or delete a materialized view, you can right-click the Materialized View folder and select Refresh to sync the latest metadata.
-
Delete Materialized View
Right-click the target materialized view and select Delete Materialized View. Review the information, and then click OK to delete the materialized view.
-
Query Materialized View
On the materialized view details page, click Query Materialized View in the upper-right corner. This opens the Ad-hoc Query page. In the SQL editor, enter an SQL statement and click Run to query the materialized view. For more information about running queries, see SQL window.
You can also right-click a materialized view and select Open Materialized View from the context menu to view detailed information, such as its schema, name, and query definition.
-
Manage materialized views using SQL
You can also use SQL to create, view, and delete materialized views. For the required syntax, see MATERIALIZED VIEW.