A materialized view is a special type of view that stores a copy of the query result. It is periodically refreshed (automatically or manually) to keep the data up to date. Unlike regular views (virtual tables, which require recalculating data each time they are accessed), materialized views contain a physical copy of the data. This allows you to directly query data from materialized views without the need to execute complex SQL statements, significantly improving query performance by trading off space for time. For more information, see Materialized views.
In OceanBase Developer Center (ODC), after you access the SQL console, you can click the materialized view tag under a database in the left-side database list to display materialized views. Double-click the name of a materialized view to open its management page. On this page, you can view the data and attributes of the view on their respective tabs. The attributes include 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.
You can create and manage materialized views in ODC.