Skip to main content

PAUSE-MATERIALIZED-VIEW

PAUSE-MATERIALIZED-VIEW​

Name​

PAUSE MATERIALIZED VIEW

Description​

This statement is used to pause the scheduled scheduling of materialized views

syntax:

PAUSE MATERIALIZED VIEW JOB ON mvName=multipartIdentifier

Example​

  1. Pause scheduled scheduling of materialized view mv1

    PAUSE MATERIALIZED VIEW JOB ON mv1;

Keywords​

PAUSE, MATERIALIZED, VIEW

Best Practice​