A materialized view is a special view that stores a copy of the query result. It is refreshed regularly (or manually) to keep the data up to date. Unlike a regular view (or a virtual table that needs to be recalculated each time it is accessed), a materialized view stores a physical copy of the data. Therefore, you can directly query the materialized view without executing complex SQL statements, which significantly improves query performance. In other words, materialized views accelerate queries by trading space for time. For more information, see Materialized views.
In OceanBase Developer Center (ODC), after you access the SQL console, click the materialized view tag under Database in the left-side database list to get a list of materialized views. Double-click a materialized view name in the list to go to the materialized view management page. On this page, you can check the data of the materialized view on the data tab or the attributes on the schema tab, including basic information, columns, and DDL statements.
ODC supports materialized views in MySQL-compatible and Oracle-compatible tenants of OceanBase Database V4.3.5.2 or later.
This chapter describes in different topics the operations you can perform on view objects in ODC.