VERIFY

Syntax

VERIFY MATERIALIZED VIEW MVNAME (mvname1,mvname2...) ORIGINALSQL query

Description

This statement is used to verify that whether a given SQL query statement can be rewritten by the specified materialized view.

Example

Verify that a specified SQL statement can be rewritten by materialized views mv.tpcds.test and mv.tpcds.t1.

verify materialized view mvname(mv.tpcds.test,mv.tpcds.t1) originalsql select c1 from t1 where id < 7;
MV_NAME    | VERIFY RESULT |        REMARKS         
---------------|---------------|------------------------
 mv.tpcds.test | true          | MV verified            
 mv.tpcds.t1   | false         | This MV is not present 
(2 rows)