obevo
obevo copied to clipboard
Support materialized tables / rerunnable tables
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
CALL ADMIN_CMD('RUNSTATS ON TABLE