obevo icon indicating copy to clipboard operation
obevo copied to clipboard

Support materialized tables / rerunnable tables

Open shantstepanian opened this issue 7 years ago • 0 comments

e.g. for db2

CREATE TABLE MaterializedTable as (

    SELECT  mydata
    FROM    mytable
    WHERE   mycolumn = 123

) data initially deferred refresh deferred GO

Syntax exists for Oracle as well. Worth testing that out alongside DATABASE LINK

And support custom modify sqls after:

refresh table .<MQTname>

CALL ADMIN_CMD('RUNSTATS ON TABLE .<MatTable> WITH DISTRIBUTION AND DETAILED INDEXES ALL')

shantstepanian avatar Jul 20 '18 19:07 shantstepanian