Support materialized tables / rerunnable tables
shantstepanian opened this issue · 0 comments
shantstepanian commented
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 . WITH DISTRIBUTION AND DETAILED INDEXES ALL')