ODC allows you to view and manage materialized views on the GUI.
Structure tree
As shown in the following figure, click the expand icon before the name of the target materialized view in the materialized view list. Its schema tree is displayed in the drop-down list. The schema tree of an object materialized view can have up to three levels. When you right-click an item in the schema tree, the context menu displays some operations that you can perform on the item. For more information about these operations, see the table of management operations in Management Operations.
Manage operations
In the materialized view list, the names of objects are sorted by the first character in ascending order by default. Right-click the target item in the structure tree. A shortcut menu appears, displaying some operation commands provided by ODC for you to manage the target object. The following table describes the management commands.
Operation |
Description |
|---|---|
| View Materialized View Properties | Enter the Properties tab, view the basic information, columns, and code of the materialized view. |
| View materialized view data | Enter the Data tab, view data in the materialized view. |
| Download | Download the SQL file of the materialized view object. |
| Copy | Select object name, Select statements, Insert statements, Update statements, or Delete statements. |
| Delete | Delete the current materialized view object. |
Attribute and data tabs
Attribute tabs:
Basic Info: View information such as Materialized View Name, Database, and Storage Mode.
Column: View information such as Column Name, Data Type, and Column Comments of the base table corresponding to the materialized view. Click the refresh icon in the toolbar to refresh the field information.
Index: View the index information of the materialized view.
Constraint: View the constraint information of the materialized view.
DDL: The definition script of the current materialized view. Click the download icon in the toolbar to download the DDL script to a local file, or click the format icon to format the script for easy viewing.
Data tab: displays the data contained in the materialized view. The toolbar provides the following function buttons:
OperationDescriptionDownload Click to download the result set data. Back to start Click to go to the first page. Previous Click to go to the previous page. Next Click to go to the next page. Jump to bottom Click to go to the last page. Show data volume Set the number of rows to be displayed on the page. By default, only 1,000 rows are displayed. Search Search for data in the materialized view by keyword. Columns Select the columns to be displayed on the page. Column mode View the data of the selected rows in the form of a table. On the Column Mode page, you can switch to the previous or next row. The column mode is convenient for viewing single-row data when a large number of columns are involved. Manual refresh Refresh the data of the materialized view on the OceanBase side. You can select a refresh method and set the degree of parallelism for the refresh. View refresh history View details of the recent refresh history of the materialized view, including the basic configuration, and the type and time of recent refreshes. 
Refresh Re-initiate an HTTP request to refresh the display of materialized view data in ODC.